Sum of a Sum...

[humorme201]

Knowing that one cannot perform a sum of a sum. What is the best workaround. We are supposed to use the value of the sum in group header #4 and sum it in group footer #2.

My sum is as follows for group header #4:
Round(Sum ({@DescrYTD}, {@Description}))-(Sum ({@DescrPrior}, {@Description}))

Any and all helpful suggestions is greatly appreciated.

 

[synapsevampire]

Try the following in the group footer, it will give you the running total if that's the intent:

numbervar MyValue:=MyValue+Round(Sum ({@DescrYTD}, {@Description}))-(Sum ({@DescrPrior}, {@Description}))

This assumes that your current summary is working.

-k

 

[humorme201]

I just tried your suggestion and it says that a number is required..I am using Crystal 9

 

[humorme201]

I changed it to currencyvar and it is almost correct...how do I reset it??

 

[dgillz]

In the group header:

WhilePrintingRecords;
If not InRepeatedGroupHeader then Numbervar MyValue:=0

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz