Formula Generating a Negative Number?

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?

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.

1 Like