How to calculate discount%

sakshikaul — Wed, 25 Nov 2020 16:16:04 GMT

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

topic How to calculate discount% in QlikView