Skip to Content

Adding a sum at the end of a break

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?

Unit total.jpg (248.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 05, 2013 at 09:48 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2013 at 05:48 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2013 at 07:16 AM

    Hi,

    Enable Break footer and then try applying the Sum Function.

    Thanks,

    Kirthi


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.