Hi
Just want to confirm how to calculate discount Percentage
Is this the formula
=((sum({stateA< Sold_Date = {">=$(From)<=$(To)"} >} quantity_sold * MRP_INR)
- sum({stateA< Sold_Date = {">=$(From)<=$(To)"} >} quantity_returns * MRP_INR))
-
( sum({stateA< Sold_Date = {">=$(From)<=$(To)"} >} [inv value])))
/
(sum({stateA< Sold_Date = {">=$(From)<=$(To)"} >} quantity_sold * MRP_INR)
- sum({stateA< Sold_Date = {">=$(From)<=$(To)"} >} quantity_returns * MRP_INR))
* Here in Above column sales amount including tax (sale and return both )
* MRP value