AnsweredAssumed Answered

Calculation field that repeats

Question asked by DebQuintero on May 4, 2011
Latest reply on May 4, 2011 by DebQuintero


Calculation field that repeats


Right now I have my fields set up like this:  "Total Amount", "Payment Amount", "Payment Date", "Balance Due".  The "Balance Due" field is the one I have as a calculation.  It is set up as Total Amount - Payment Amount .

The "Payment Amount", "Payment Date" and "Balance Due" fields are set up as repeating fields with 2 lines, because more than 1 payment can be applied at different times.  For example:

Total Due = $100.  Payment Amount = $25 Payment Date = 1/5/2011  Balance Due (caclulation)= $75

How do I apply a second payment to the repeating field so that it calculates the new balance due?