Skip to main content

IF statements + calculations

  • February 17, 2022
  • 2 replies
  • 35 views
N

Hi community!

I am trying to track the status of payments which are made in multiple installments. For instance, we may make a payment for $400,000 but pay quarterly installments of $100,000.

I would like to have the Total Paid field auto calculate using the payment schedule in the table. Total paid would equal {payment one} + {payment 2} + {payment 3} + {payment 4} but only when the corresponding payment status field has been marked as “complete” AND the corresponding payment date be in the current year (01/01/22-12/31/22).

Any ideas?

Thanks!

2 replies

J
Forum|alt.badge.img+18

You’ll want to make use of a second table for “Payments”. One record for each Payment or Installment, and each Payment/Installment record linked back to the “Obligation” or “Invoice” it is paying. Each Payment/Installment can then have its own date stamp and amount.

Then you can use a Rollup field to total all Payments/Installments that are linked to a single Obligation or Invoice.

N
  • Nina_Casalena
  • Author
  • New Participant
  • February 18, 2022

You’ll want to make use of a second table for “Payments”. One record for each Payment or Installment, and each Payment/Installment record linked back to the “Obligation” or “Invoice” it is paying. Each Payment/Installment can then have its own date stamp and amount.

Then you can use a Rollup field to total all Payments/Installments that are linked to a single Obligation or Invoice.


Thank you! I will give that a try.

Terms & ConditionsAccessibility statement