How to calculate discount%

[sakshikaul]

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