Need text edit help on calculated column | Community
Skip to main content
C
CoriSt
Level 2
March 10, 2021
Question

Need text edit help on calculated column

  • March 10, 2021
  • 1 reply
  • 370 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity Advisor
Community Advisor
March 11, 2021

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.

Terms & ConditionsAccessibility statement

Loading footer...