Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Percentage nightmare

Topic Labels: Formulas
Solved
Jump to Solution
275 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello good people of airtable!

I would like to know how to:

add two percentages together, then minus that percentage from an amount? to get the sum of that calculation

in this case-

FEE (£40) - (CUT (10%) + TAX (20%) = 30%) = PROFIT (£28)

Screenshot 2021-05-19 at 7.31.16 PM

1 Solution

Accepted Solutions

Welcome to the Airtable community!

Try converting {CUT} to a rollup field, then use this formula

{FEE} * (1 - ({CUT} + {TAX}))

When converting the lookup field to a rollup field, you can use the SUM(values) formula. Since there is only one value, the “sum” will the the same as the original value.

In general, I recommend using rollup fields instead of lookup fields in formulas whenever possible. Lookup fields have some weird behaviors in formula fields.

See Solution in Thread

2 Replies 2

Welcome to the Airtable community!

Try converting {CUT} to a rollup field, then use this formula

{FEE} * (1 - ({CUT} + {TAX}))

When converting the lookup field to a rollup field, you can use the SUM(values) formula. Since there is only one value, the “sum” will the the same as the original value.

In general, I recommend using rollup fields instead of lookup fields in formulas whenever possible. Lookup fields have some weird behaviors in formula fields.

Thank you Kuovonne! very much appreciated :raised_hands:t2: