Help

Re: Percentage nightmare

Solved
Jump to Solution
975 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Luke_Nichol
5 - Automation Enthusiast
5 - Automation Enthusiast

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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: