Total for a group

[Bennie47250]

Using Crystal version 7

Must be brain dead this AM.

I have a formula that gives me the total cost (Qty * Cost) in the Group Footer #3.

Now I would like to get the total of this formula in the Group Footer #2 section.

How?

Thanks
Bennie

 

[lbass]

What is the exact formula you are using in gf#3? If it is simply:

sum({@yourqtyxcostcalc},{table.group3})

...then you should be able to use:

sum({@yourqtyxcostcalc},{table.group2})

-LB

 

[Bennie47250]

The exact formula I'm using is: Qty * Cost

 

[lbass]

So I guess we can assume that Qty and Cost are repeating in the detail data, and that Group #3 is designed to address this?

You can always use a variable in the situation--it's just not the simplest solution:

//{@reset} to be placed in the Group #2 header:
whileprintingrecords;
currencyvar x := 0;

//{@accum} to be placed in the Group #3 footer:
whileprintingrecords;
currencyvar x := x + {@qtyxcost};

//{@display} to be placed in GF#:
whileprintingrecords;
currencyvar x;

If your formula is a number, not a currency, replace currencyvar with numbervar.

-LB