Hi,

i am trying to modify a report that someone else wrote. it is for customer statements. The report is grouped by invoice number, and shows charges (positive values) in the charges column, and shows Payments and credits(negative values) in the credits column. As they are grouped by invoice, there is a third column which shows the total balance on the invoice. It is working fine, EXCEPT FOR THE LAST INVOICE ON THE LIST. For some reason, the total is tripling!!! I have tried several things, and I haven't been able to figure out why...

here is the formula they used for that total field:

If {V_LASER_AR_STMNT.TOT_MARKER}<>'X' then
Sum ({V_LASER_AR_STMNT.CHARGES}, {@ControlInvoice}) + Sum ({V_LASER_AR_STMNT.CREDITS}, {@ControlInvoice})
else
(Sum ({V_LASER_AR_STMNT.CHARGES}, {@ControlInvoice}) + Sum ({V_LASER_AR_STMNT.CREDITS}, {@ControlInvoice})) + ({V_LASER_AR_STMNT.CHARGES}-{V_LASER_AR_STMNT.CREDITS})

if you remove your suppression you will likely see where the issue is.
One possible solution:
Use a Running Total that uses evaluate criteria that matches your suppression criteria.


Edited by DBlank - 14 Oct 2016 at 8:23am

are you using evaluation formulas in the RTs?
You also might just be able to use on change of and point to a PK from the main table if it has duplicate data in it.