It would be nice if I could set up different “levels” of aggregator functions / expressions. I have run into this problem a couple of times but especially when trying to get correct percentages but my example will be simple. I am trying to create a report to look at Users and their hours.
User YTD Hours is a set number that will be the same in base row. (non grouping row)
- In the 1st grouping, I need the aggregator to MAX so I can see the correct number of hours for the Owner.
- In the 2nd grouping, I need the aggregator to SUM so I can see the correct number of hours that total for two of the Owners.
- In the 3rd grouping, I need to the aggregator to SUM again so I can see the total number of hours on a company level.
My Idea: Set them up like the groupings. Make the last aggregator function the same for the next groupings if no more is needed or written in.
Example:
aggregator.0.function=MAX
aggregator.0.valuefield=
aggregator.0.valueformat=
aggregator.1.function=SUM
aggregator.1.valuefield=
aggregator.1.valueformat=
aggregator.2.function=SUM
aggregator.2.valuefield= (Since this would be the same as previous aggregator function, it would not need to be written)
aggregator.2.valueformat=
