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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes