Summary

[paljnad]

Hi,

I have a Crystal Report v 10 report that is grouped by Manager and Unit.

I have the following formula in the detail section:

@Redemption:
IIf({NET}='Y',IIf({DOLLARS}<0,{DOLLARS},0),IIf({REDEMPTIONS}+{CHARGE}<{PURCHASES},0,{PURCHASES}-({REDEMPTIONS}+{CHARGE})))

And I have the following formula in the group footer by manager section:

@Total Redemption:
IIf({NET}='Y',IIf((Sum ({DOLLARS}, {A.MANAGER}))<0,Sum (DOLLARS}, {A.MANAGER}),0),Sum ({@Redemptions}, {A.MANAGER}))

Now, I need to display the SUM of the Total Redemptions field i.e. basically add up all the values of the Total Redemptions but it wont allow me to do that. It wont allow me to summarize an already summarized field.

Is there a way I can add all the values of Total Redemptions?

 

[lbass]

You can use a variable, as in:

whileprintingrecords;
currencyvar x := x + {@Total Redemption};

Then in the report footer, use:
whileprintingrecords;
currencyvar x;

If your formula is a number, not a currency, use numbervar instead.

If you want this summary at a group footer level, add a second variable that has a reset formula in the group header.

-LB

 

[paljnad]

That worked beautifully ! Thank you

We needed to put it in the group footer so put a reset formula in the group header.