Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Need text edit help on calculated column

Avatar

Level 2

I am trying to divide assignment percent by 100. It works in an assignment report, but when I try it in a task report as shown below it does not work.

aggregator.displayformat=val

aggregator.function=SUM

aggregator.namekey=FTE

aggregator.valueexpression=DIV({primaryAssignment}.{assignmentPercent},100)

aggregator.valueformat=doubleAsDouble

displayname=FTE

textmode=true

valueexpression=DIV({primaryAssignment}.{assignmentPercent},100)

valueformat=doubleAsDouble

1 Reply

Avatar

Community Advisor

I was trying to do something similar earlier this week (https://one.workfront.com/s/feed/0D54X00006SHcOcSAL?t=1615467801117) -- I had a calculated column in a report and wanted to SUM it with an aggregator.valueexpression='my formula'

Text mode gurus @Anthony Imgrund‚ and @Doug Den Hoed‚ both told me, 'sorry, nope, can't do that' and suggested a calculated field that can then be pulled into a report and summed.

I'm also going to bring the need to do this up with the team that's working on the New Reporting experience.