Post Author: mjm
CA Forum: General
I am trying to create a report that will sum only duplicate values. ie: ItemID, Qty
a, 11 = Total of all duplicated "a" lines.
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.