Skip to Content
Former Member
Jul 03, 2007 at 07:35 PM

Sum Duplicate values Only


Post Author: mjm

CA Forum: General

I am trying to create a report that will sum only duplicate values. ie: ItemID, Qty

a, 3

a, 1

a, 6

a, 4

a, 11 = Total of all duplicated "a" lines.

b, 5

b, 7


I have tried counting on "a" in a Running Total, then (if Count>1, qty, else 0) for the line totals, but I can't get the system to total Qty. I can also suppress the 1st line in the Section Expert, but the suppressed Qty detail values still add to the Total Qty.

Any help would be greatly appreciated.