Need to total group running totals ?

[Former Member]

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

[Former Member]

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

[Former Member]

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.