Expand my Community achievements bar.

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.