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. I also want to total the patient responsibility fields that are created above but have been unable to do so. Any Ideas?
Thanks