Summarizing A Calculated Field In An Assignment Report | Community
Skip to main content
Eric_D_Miller
Eric_D_Miller
Level 5
March 24, 2025
Solved

Summarizing A Calculated Field In An Assignment Report

  • March 24, 2025
  • 1 reply
  • 568 views

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-fields/td-p/561929 

 

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?

Best answer by Sven-iX

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.

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
March 24, 2025

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
    Eric_D_MillerAuthor
    Level 5
    March 25, 2025

    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
    Community Advisor
    Sven-iXCommunity AdvisorAccepted solution
    Community Advisor
    March 25, 2025

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...