expression to calculate discount

[Anonymous]

Hi All,

Following is the expression to calculate discount%. Its giving wrong value

Here sales value is without tax

=((sum({stateA< Year = {"$(=Max(Year)-2)"}>} quantity_sold * MRP_INR)

- sum({stateA< Year = {"$(=Max(Year)-2)"}>} quantity_returns * MRP_INR))

-

( sum({stateA< Year = {"$(=Max(Year)-2)"}>} [sales  value])))

/

(sum({stateA< Year = {"$(=Max(Year)-2)"}>} quantity_sold * MRP_INR)

- sum({stateA< Year = {"$(=Max(Year)-2)"}>} quantity_returns * MRP_INR))

[PrashantSangle]

Hi,

can you explain little bit more.

how your data look like?

why are u using alternate state?

what is the expected output?

what challenges are you facing?

Regards,

[Anonymous]

Here under discount column I am getting higher value as expected and I am using three different multibox for current year, previous year and before previous year