Trying to Summarize Fields in Grouping

[FrankFo]

Trying to figure out what I am doing wrong. I have a report where I selected Summarize on several field using Sum or Average. I would expect the column to add up but notice that in some cases the total is reflecting zero. Below is a screen shot of the report and below that I pasted the calculations as it shows I the text mode:

Planned Hours

textmode=false

valuefield=workRequired

valueformat=compound

viewalias=workrequired

aggregator.function=SUM

aggregator.valuefield=workRequired

aggregator.namekey=plannedhour.plural.abbr

aggregator.displayformat=minutesAsHoursString

aggregator.valueformat=compound

descriptionkey=plannedhour.plural

listsort=intAsInt(workRequired)

namekey=workRequired

querysort=workRequired

section=0

shortview=false

stretch=0

width=80

linkedname=direct

Actual Hours

aggregator.displayformat=minutesAsHoursString

aggregator.function=SUM

aggregator.namekey=actualworkrequired

aggregator.valuefield=actualWorkRequired

aggregator.valueformat=compound

displayname=

linkedname=direct

namekey=actualworkrequired

querysort=actualWork

valuefield=actualWorkRequired

valueformat=compound

viewalias=actualworkrequired

% Complete

aggregator.displayformat=asPercent

aggregator.function=AVG

aggregator.namekey=percentcomp

aggregator.valuefield=percentComplete

aggregator.valueformat=val

descriptionkey=percentcomplete

listsort=doubleAsDouble(percentComplete)

namekey=percentcomp

querysort=percentComplete

tile.attribute.height=12

tile.name=component.percentcompletelistview

type=tile

valuefield=percentComplete

valueformat=asPercent

width=80

[EXP_-_DustinMa]

Hey Frank, By chance are the results in your report parent tasks? If so, Workfront won't sum those as they themselves are a sum of their child tasks. Thanks! Dustin Martin Assigned Support Engineer Workfront

[FrankFo]

Thanks Dustin the one task that had information but the aggregate was showing 0 did have subtasks. Appreciate you pointing that out. Frank Fornataro DHHS

[EXP_-_DustinMa]

You're welcome Frank! Dustin Martin Assigned Support Engineer Workfront