Adding a sum at the end of a break

[former_member672670]

Hey Guys,

I need to sum the Total Hrs for all the "Resource Type Name" for each "Unit" in my report (basically sum all the blue cells for a "Unit"). The variable used for "Unit" in the report is "Unit Number - Name". I have attached the snapshot of the report below. There are more units in the report. I have only provided one here. Can you suggest me how to achieve the solution?

[former_member225163 · Accepted solution]

Hi Jeevan,

As per the snapshot of your report, It looks like you have applied two breaks in the report.

As you need sum at Unit column level,

> select the Unit column

> go to break properties

> Check show break footer option

> use Sum(Total Hrs) in break footer of Total Hrs column.

Hope this helps..

Cheers,

Bala

[Former Member]

Hi,

Enable Break footer and then try applying the Sum Function.

Thanks,

Kirthi

[Former Member]

Hi Jeevan,

have you tried with right click on total(blue cell) and apply sum?

If it is not working then add a cell in total column below each Unit(Break) and write a formula as

=Sum([Total]) foreach([Unit])

Please check