Group Sum excluding Supressed values

[DerbyNeal]

Hi,

Please can someone help?

I need to display a Group Total (Running Total/Sum of) of all fields shown. But - it must exclude the 'supressed' values. Do I need to use a formula? If not, what do I need to set?

(NB: The supressed values are duplicated values).

I'm using Crystal Version 9 (and 10).

Many thanks,

Neal

 

[DerbyNeal]

To explain further....

Basically, the 'Total' field is adding the supressed values to the final amount. The 'Detail' field contains Positive and Negative values (as well as supressed values).

Other 'Total' fields within the report are OK where 'Detail' fields Positive values and supressed Values exist.

Thanks,

Neal

 

[Madawc]

Summary totals add up everything, or everything in a group. You can do 'distinct count', but nothing more fancy.

A running total can evaluate using a formula. Use the same formula that you use to suppress and it should be OK

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10