How to show the sum of hour types in each column on an Hours report? | Community
Skip to main content
CelSal01
CelSal01
New Participant
June 26, 2025
Solved

How to show the sum of hour types in each column on an Hours report?

  • June 26, 2025
  • 1 reply
  • 519 views

I created an hours report that breaks down hours by hour type in separate columns. Is it possible to sum each column? I tried the following but it gives me a sum of all the hours, not just the "X40" hours I'm filtering for.

 

aggregator.displayformat=doubleAsInt
aggregator.function=SUM
aggregator.namekey=hours
aggregator.valuefield=hours
aggregator.valueformat=doubleAsInt
displayname=Test SUM
linkedname=direct
namekey=hours
querysort=hours
valueexpression=IF({hourType}.{name}="X40",{hours},0)
valuefield=hours
valueformat=

Best answer by Sven-iX

works fine for me across 3 groupings

example column

valueexpression=if({hourType}.{name}="General Overhead", {hours}, 0) valueformat=double aggregator.valueexpression=if({hourType}.{name}="General Overhead", {hours}, 0) aggregator.function=SUM aggregator.valueformat=doubleAsDouble aggregator.displayformat=double displayname=General Overhead namekey=hour.plural width=65 querysort=hours listsort=doubleAsDouble(hours)

1 reply

Sven-iX
Sven-iX
New Participant
June 26, 2025

Have you tried adding the calculation to the aggregator:

aggregator.displayformat=doubleAsInt aggregator.function=SUM aggregator.namekey=hours aggregator.valueexpression=IF({hourType}.{name}="X40",{hours},0) aggregator.valueformat=doubleAsInt displayname=Test SUM linkedname=direct namekey=hours querysort=hours valueexpression=IF({hourType}.{name}="X40",{hours},0) valuefield=hours valueformat=
CelSal01
CelSal01Author
New Participant
June 26, 2025

Thanks, @sven-ix. It worked, but only if grouped by hour type. Is there a way to do it so it shows the sum per column at the owner grouping and not have to group by hour type to show the sum like in the attached screenshot?  

Sven-iX
Sven-iXAccepted solution
New Participant
June 26, 2025

works fine for me across 3 groupings

example column

valueexpression=if({hourType}.{name}="General Overhead", {hours}, 0) valueformat=double aggregator.valueexpression=if({hourType}.{name}="General Overhead", {hours}, 0) aggregator.function=SUM aggregator.valueformat=doubleAsDouble aggregator.displayformat=double displayname=General Overhead namekey=hour.plural width=65 querysort=hours listsort=doubleAsDouble(hours)
    Terms & ConditionsAccessibility statement

    Loading footer...