Trying to Summarize Fields in Grouping
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