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

Formula Generating a Negative Number?

Topic Labels: Formulas
754 2
Showing results for 
Search instead for 
Did you mean: 

My formula is ({Fee Before Disc} *Discount) - {Fee Before Disc}
Despite it being a positive number subtracting the discounted amount, it ends up being a negative number.

Example: 1800 -40% disc =1080 but it shows up as -1080?

Why would this generate a negative number? How can I fix this?

2 Replies 2

The way your formula is written would produce a negative number.

(1800 * .4) - 1800 = -1,080

You’ll want to rewrite your formula to this:

{Fee Before Disc} - ({Fee Before Disc} * {Discount})

You are brilliant! Thanks so much for helping me figure this out.