Hi All,
I am trying to create a report that can show what is our running balances on sales to meet our quota, i use invoices and memos as my references for the report, and group it by doc type, and on the formula for the running balances is =IIf(fARInvoice.DocType]='CRM', 10000000+SUM(MARInvoice.CuryLineTotal]), IIf(fARInvoice.DocType]='INV', ((10000000-SUM(MARInvoice.CuryLineTotal]))*(-1)), IIf(fARInvoice.DocType]='DRM', ((10000000-SUM(MARInvoice.CuryLineTotal]))*(-1)), 0)))
how can i end up on the correct report for this