Summing conditionally calculated fields

[tfish]

In my report, I have a calculated field that determines an account balance by two criteria (an account type and the sum of dr/cr's in the account). This is done with a series of IF, ElseIf statements. I want to sum the resulting column(s) independently but Crystal will not let me generate a grand total or running total on this field for the report footer. What am I doing wrong?

 

[kenhamady]

Post the formula.

It probably has a total in it somewhere, which means you have already used your first strike. We either have to re-write the formula without the total, or you will have to use a variable to create a running total. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[tfish]

Thanks for the assist, Ken. I've gone back to the drawing board and I'm re-writing the running total formula manually. I think I'm on the right track; it's only a matter of time at this point.

 

[Dond12]

I run into this problem all the time. First, create a KOUNTER variable with the formula:

whileprintingrecords ;
shared NumberVar KOUNTER := KOUNTER + {value to be added} ;

Now, create a variable called RESET with the formula:

whileprintingrecords ;
shared NumberVar RESET := 0 ;

Put the RESET variable in the group header, or wherever you want the accumulated total to reset to zero, and SUPPRESS it.

Put the KOUNTER variable in the DETAILS section, and when you run the report, KOUNTER will give you a running total and will start over whenever it encounters the RESET variable (i.e., whenever the HEADER changes)..