Skip to Content
author's profile photo Former Member
Former Member

How to have Report Grand Total add up the values of a group summary field containing a formula

I am using a formula at the group level to display a total based on varyingcriteria. In some instances, it will pull an average number and in others, it will sum up other summary fields in the group. Therefore, it does not make sense to sum the orgiginal detail field in the grand total. I need to take all the results from my formula summary field and add them up in the report total.

Is there a way to do this? I have seen postings about putting formulas in the report header and then iin report footer about 'WhilePrintingRecords' But not sure I understand the steps involved. Please help with some specific detail.

The formula in my group field that I need to total at the report level:

if {@NBVerify} = TRUE then (Sum ({@Benchmark NB}, {@fullname}))*(({?End Date}-{?Start Date})/({?Average Calc}*30)) else Sum ({@Scheduled Count}, {@fullname})+Sum ({@Open Count}, {@fullname})+Sum ({@Hold Count}, {@fullname})

Thanks for any help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 15, 2015 at 02:39 PM

    Hi John,

    Modify the formula to:

    whileprintingrecords;

    numbervar subt := if {@NBVerify} = TRUE then (Sum ({@Benchmark NB}, {@fullname}))*(({?End Date}-{?Start Date})/({?Average Calc}*30)) else Sum ({@Scheduled Count}, {@fullname})+Sum ({@Open Count}, {@fullname})+Sum ({@Hold Count}, {@fullname});

    numbervar gtotal := gtotal + subt;

    subt;

    Create another formula with this code and place this on the Report Footer:

    whileprintingrecords;

    numbervar gtotal;


    -Abhilash

    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.