Summarizing A Calculated Field In An Assignment Report

[Eric_D_Miller]

Hello,

I am attempting to summarize a calculated field that is found on the Task level. My calculated field is formatted as a Number.

When I pull this calculated field into an Assignment report I get no option to Summarize it.

I tried this method here with no success:
https://experienceleaguecommunities.adobe.com/t5/workfront-questions/summarize-column-of-calculated-... 

The code mentioned in that post is here:

ggregator.displayformat=HTML
aggregator.function=SUM
aggregator.valueexpression=NUMBER({DE:FIELD NAME})
aggregator.valueformat=HTML
displayname=
linkedname=direct
namekey=FIELD NAME
querysort=DE:FIELD NAME
textmode=true
valueexpression=NUMBER({DE:FIELD NAME})
valuefield=FIELD NAME
valueformat=customDataLabelsAsString

Only when I used that all I got was 0 as a value. Any ideas if this code needs tweaked a bit in order to work for an assignment report, pulling data from the task level?

[Sven-iX]

You don't need this solution if your field is type number (it's for when it's NOT number and you want to sum it)

I tested a calc field on a task, that I wanted to pull in on an assignment report: The field is type number - and the report UI shows the expected "summarize" options... 

Check that calculated field that it indeed produces a numeric value? 

[Eric_D_Miller]

Hi Sven,

Confirmed that my calculated field is indeed formatted as Number. Is there anything in my code that would remove my formatting?

CONCAT(FLOOR(PROD({workRequired}, {project}.{DE:customfield}) / 60), ".", ROUND((PROD({workRequired}, {project}.{DE:customfield}) - FLOOR(PROD({workRequired}, {project}.{DE:customfield}) / 60) * 60) / 60 * 100, 0))

I am multiplying the Planned Hours by a field on the project level, but I am including a decimal.

[Sven-iX · Accepted solution]

your expression above is a CONCAT - which is, by definition, a string. 

I'm not really following the calculation or why you do the concat - but true putting a NUMBER() around the whole thing.

[Eric_D_Miller]

Adding NUMBER() worked! Thank you Sven as always.