How to remove the duplication of Invoice amount while summing them in customer saved search?
Criteria:
transaction:type - Invoice
Result:
state - group
transaction:amount - sum
transaction:document number - group
When I run this search all the amount in that Invoice gets displayed again and the same amount is added twice which leads to twice the sum of original amount.