Level 1
Level 2
Melden Sie sich an, um alle Badges zu sehen
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?
Gelöst! Gehe zu Lösung.
Anhand von Themen werden Community-Inhalte kategorisiert und Sie können so relevanten Inhalt besser finden.
Zugriffe
Antworten
Likes gesamt
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.
Zugriffe
Antworten
Likes gesamt
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?
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.
Zugriffe
Antworten
Likes gesamt
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.
Zugriffe
Antworten
Likes gesamt
Adding NUMBER() worked! Thank you Sven as always.
Zugriffe
Antworten
Likes gesamt
Zugriffe
Likes
Antworten