Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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.