Remove supressed record from total

[kpetree]

I'm using Crystal 10 and I have a report that shows invoices due and totals them up. In the case of a duplicate invoice number is supresses the record but it still counts the supressed record in the total. How can I make the total not count the supressed records? Thanks!

 

[lbass]

If you can't remove the duplicate, then you need to use running totals that sum the amount, evaluate on change of field or group (if you grouped on it): invoice number, reset never for a grand total. The running total should be placed in a footer section.

-LB

 

[kpetree]

Thanks LB, that worked!