Grand total for a running total field

[SDElliott]

Hi - I'm using 8.5, and I have a running total field that calculates the difference (DIFF) value between 2 numeric fields in the database. This DIFF is displayed once on the report for every account # in the database. That is fine, but I want to include a grand total on the DIFF - and I can't seem to figure out how to do a SUM on this running total field. Is there a way to get a grand total on a repeating running total field? Much thanks!

 

[pgtek]

hi

sorry you can have a sum on a running total

cheers

pgtek

 

[lbass]

If the running total is set up so that {@diff} is summed for every record and reset on change of {table.acctID}, then all you have to do is create a new running total set up the same way except you would change the reset to "never"--this will give you the grand total.

If this is not how your running total is designed, please provide the specifics, and I'm sure someone can help.

-LB

 

[kenhamady]

Is this running total a formula or a running total object?
If a formula, please post it. if a running total please post the settings used.

Either way, as a last resort, you should be able to use a variable to sum these values.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com