I have a report that repeats an invoice if more than one payment exists. I need to include the invoice amount in a subtotal only if it is unique. Is this possible?
Inv. Amt. Pmt. Amt.
Inv 1 100.00 100.00
Inv 2 200.00 100.00
Inv 2 200.00 100.00
-------- -------
Desired subtotal 300.00 300.00
Thanks for any help.
Joyce
Inv. Amt. Pmt. Amt.
Inv 1 100.00 100.00
Inv 2 200.00 100.00
Inv 2 200.00 100.00
-------- -------
Desired subtotal 300.00 300.00
Thanks for any help.
Joyce