Post Author: hamish_sco
CA Forum: Formula
Hi there, I wondered if anyone knows if it is possible to do the following;I have data columns for 'invoice number', 'amount' and 'amount paid'.There is some duplication in the data - an invoice can be paid in several installments, but this puts in a new row containing the invoice number and amount. When the data is Sum then it is incorrect.I can do a distinct count to find the actual number of invoices, but I would like also to Sum the amount of all invoices, but this needs to ignore any duplicate entries. Obviously this should ideally be done database side, but the procedures I have do not allow this, so I wondered if this could be done Crystal side? CheersHamish