Help

Formula Generating a Negative Number?

Topic Labels: Formulas
1975 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Cristy_Lenz
4 - Data Explorer
4 - Data Explorer

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
AlliAlosa
10 - Mercury
10 - Mercury

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})

Cristy_Lenz
4 - Data Explorer
4 - Data Explorer

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