Sum records without supressed amounts.

[MB57630]

thread767-1436620

I have a report where the records are visually suppressed if there are duplicates. It is not suppressing the row, which is how I want it, but when I total the amounts it is totaling all the values, including the suppressed amounts. Is there a way to total the amounts like the figure below?

50 30
22
20
19
21
15 16

 

[lbass]

You should insert a running total that evaluates on change of the field you are summing--if that's really what you mean. The question I would have is how do you know what is a duplicate versus a valid value that is the same as the previous one. Ordinarily you would evaluate on change of some unique ID field. The running total would go in the footer.

-LB