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

Need to total group running totals ?

Post Author: smarkta

CA Forum: Formula

I am writing a report that contains 3 groups. The lowest level group has repeating data in each record of the second group. I have created running totals for each group that are accurate by selecting the group to evaluate and reset on. now I need to basically sum the results of the all the group running totals but have had no success. any tips on how to do this would be greatly appreciated.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2008 at 02:55 PM

    Post Author: sharonmtowler

    CA Forum: Formula

    create manual running totals for an grand calculation. if you place the reset in the header and use the same field for the calc, it should produce correctly in the report footer.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 18, 2008 at 01:44 PM

    Post Author: pandabear

    CA Forum: Formula

    Hi smarkta,

    I think sharon's right. You could store the totals at the group level, add them up and

    total everything at the end. If the running group totals that you now have are working,

    you could also just make 3 new running totals, don't reset them, and then place them

    in a formula: groupT1 + groupT2 + groupT3.

    You could also try rewriting the query to get the group totals and the grand totals.

    Not only is this faster, but it's easier.

    Hope this helps,

    The Panda

    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.