what will be the expression to create sell through

[Anonymous]

Hi

what will be the expression for obtaining sell through on basis of a particular columns .the data should be received in indian rupee rate

Please help

Thanks in advance

[arvind_patil]

Hi Saksham,

You need to calculate sale like below:

(Sum(Quantity)*(Sum(Price)*Exchange Rate) )As Sale

Thanks,

Arvind Patil

[Anonymous]

is this correct?

sum(quantity sold)-sum(quantity Returns)/sum(quantity received)