cancel
Showing results for 
Search instead for 
Did you mean: 

totaling a formula that uses running totals

Former Member
0 Kudos

Post Author: rbnielson

CA Forum: Formula

Here is the issue I am printing out a statement, for the purpose of the statement I am printing only on a change of invoice number. I am also changing the total so that if there is no insurance payment the invoice total is 0 as far as the patient responsibility. the formula is

IIF ({#Invoice Ins Payments}<>0,{#Invoice Charges} - ({#Invoice Ins Payments}{#Invoice Patient Payments}{#Invoice Practice Adj}) ,0 ) this formula works fine in the group footer for change of invoice. The problem is I need to total this fromula field and can't find a way to do it.

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: pandabear

CA Forum: Formula

Hey rb,

Try creating a local numberVar (numHold) and a shared global numberVar (numTotHold).

Then something like :

numHold = IIF ({#Invoice Ins Payments}<>0,{#Invoice Charges} - ({#Invoice Ins Payments}{#Invoice Patient Payments}{#Invoice Practice Adj}) ,0 ) ;

numTotHold = numTotHold + numHold;

Hope this helps,

The Panda