Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

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.