Nov 19, 2019 01:32 PM
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?
Nov 20, 2019 07:44 AM
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})
Nov 20, 2019 07:56 AM
You are brilliant! Thanks so much for helping me figure this out.