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

Calculation field that repeats

Title

Calculation field that repeats

Post

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?

thanks

• 1. Re: Calculation field that repeats

Although it's better to NOT use repeating fields to solve this type of problems, balance due could be a simple ( not repeating ) field with calc:

Total Due - Sum ( Payment Amount )

• 2. Re: Calculation field that repeats

thanks, this works very nicely.  Appreciate your quick response