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
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
Add a comment