2 Replies Latest reply on May 4, 2011 1:10 PM by DebQuintero

    Calculation field that repeats



      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?