Hello,

In our current table "AR_AgedInvoiceReportWrk" has a field called balance however, it is not calculating the customer balance properly. If I create a formula the properly calculate the balance would it be:

if {AR_AgedInvoiceReportWrk.Balance} = "Y" then

AgingAmt1 + AgingAmt2 + AgingAmt3 + AgingAmt4

Endif

I need the formula to be able to calculate negative dollar amounts (credits) as well as positive dollar amounts.

Thanks!