Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

# Discount formula and multiple functions

Topic Labels: Formulas
Solved
527 3
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hello everyone! I’m trying to migrate from Google Sheets to Airtable, but still having issues creating a budget template for my projects…

As you can see in the screenshot below, my “total” and “tax” fields are working fine when I add numbers to the fields “QTY” and “COST”, however, my “SUBTOTAL” formula (also in the screenshot) always stays at zero, regardless if I do or do not add numbers to the fields “freight” or “Discount”.
I also would like my subtotal field to calculate the formulas even if “discounts” and “freight” are numbered as zero as I don’t always get a discount or have to pay for freight.

Can someone please help me understand what I’m doing wrong and how to solve it? It would be very much appreciated!

1 Solution

Accepted Solutions
8 - Airtable Astronomer

Welcome to Airtable community.

First of all the discount field includes already numbers in percent formatting. So If you want to apply this discount the sum of {total} + {tax} + {freight}, you shouldn’t divide the discount again with 100. The correct the formula for the subtotal is:

({total} + {tax} + {freight})*(1-{discount})

The following formula returns the value of discount:

({total} + {tax} + {freight})*({discount})

Both formulas work even freight or discount is equal to zero.

Thanks

3 Replies 3
8 - Airtable Astronomer

Welcome to Airtable community.

First of all the discount field includes already numbers in percent formatting. So If you want to apply this discount the sum of {total} + {tax} + {freight}, you shouldn’t divide the discount again with 100. The correct the formula for the subtotal is:

({total} + {tax} + {freight})*(1-{discount})

The following formula returns the value of discount:

({total} + {tax} + {freight})*({discount})

Both formulas work even freight or discount is equal to zero.

Thanks

4 - Data Explorer

Hi @Dimitris_Goudis
Thank you so so much for this
The first formula worked for me!
The second one did not calculate the subtotal if a discount isn’t applied…
I really appreciate your time and help.
Thank you.

8 - Airtable Astronomer

That’s good!
For the second case, if the {% discount}=0 then the result should be 0. This is the value of the discount.
Isn’t it something you want?