Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

No of Payments Summary Formula

Topic Labels: Data Formulas
Solved
Jump to Solution
782 1
cancel
Showing results for 
Search instead for 
Did you mean: 
afxveejay
4 - Data Explorer
4 - Data Explorer

Hi I am new to airtable and trying to figure out the formula, but stuck on figuring how to accomplish the following.  We have the following fields

Deal Value = X Amount

No of Payments = can be 1 or more 

  • If its 1 = then we need the formula to be (Deal Value / 1) = goes in Payment #1 Amount Column
  • If its > 1 = then we need the Deal Value / No of Payments = go to multiple Payment Columns (Payment #2, Payment #2....... Payment #12) 

afxveejay_0-1677638944007.png

We have created multiple columns with a formula as Payment #2, Payment #3..... Payment #12 with the formula as {Deal Value}/ {No of Payments). However, if the No of Payments is 1, this scenario replicates for that row. We like to write a formula for the payment fields (2-12) which can derive the payment amount by 

IF No of Payments = 1, then "0" ELSE  {Deal Value/No of Payments) in the formula field. 

Any insights, what formula should I use for the payment fields to achieve this output? Thank you all very much. Veejay

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think you've pretty much got it figured out actually, the line you have in bold is exactly the logic you'd need

Screenshot 2023-03-01 at 4.56.16 PM.png

IF(
  {No of Payments} = 1,
  0,
  {Deal Value} / {No of Payments}
)

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think you've pretty much got it figured out actually, the line you have in bold is exactly the logic you'd need

Screenshot 2023-03-01 at 4.56.16 PM.png

IF(
  {No of Payments} = 1,
  0,
  {Deal Value} / {No of Payments}
)