Not Sum Suppressed Duplicate Records

[slimshades26]

I need to sum field {A.ISAVL} which is also grouped SUM OF {A.ISAVL}. My road block is the suppressed duplicate (by field) is being added into the sum which makes the sum incorrect. Only sum printed records. Thanks for any response. ss26

 

[dgillz]

As you have discovered, suppressed records still evaluate in sub and grand totals.

You need to create a running total field to evaluate these types of situations, or exclude the values from your report altogether with a record selection formula.

Let me know if you have any questions. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[slimshades26]

Again you have been helpful. Thanks ss26