We are tracking two sale values on our e-commerce platform currently -
Final Sale Price - the amount the user paid during checkout
Discount applied - the amount of discount applied to the purchase by the user during checkout
so in reporting, when we try to isolate the actual sale value across multiple purchase instances, which is a simple formula of Revenue - Discount, I start seeing negative values which is throwing up a wrong column total.
Example: Final sale price for one instance was 0$ but the discount applied was 99 and so the sales(actual) is being reported as -99$. Is there a smart way to use calculated metrics to solve for these negative values? Wondering if anyone else faces the same issue?