Expression error

[sakshikaul]

Hi

This below expression for cumulative sales is not giving correct result

=BELOW(TOTAL(RangeSum(Above(TOTAL Sum( { <Sold_Date= {">=$(From)<=$(To)"} >} [sales price]* quantity_sold)-sum({ <Sold_Date= {">=$(From)<=$(To)"}>}[sales price]* quantity_returns)) , 0, RowNo(TOTAL))))

[sakshikaul]

Please help stalwar1‌

[sushil353]

Hi Sakshi,

It is better if you can share a sample qvw for the same.

Otherwise in your case you should try the as of calendar for commutative calculations.

HTH

Sushil 

[rangam_s]

Try this

rangesum(above((Sum( { <Sold_Date= {">=$(From)<=$(To)"} >} [sales price]* quantity_sold)-sum({ <Sold_Date= {">=$(From)<=$(To)"}>}[sales price]* quantity_returns)),0,RowNo()))

[sakshikaul]

I am not getting correct values

[sunny_talwar]

What are the correct numbers?

[sakshikaul]

MRP cumulatve Achevements

966,869.00

3,813,529.00

1246490.30

[sunny_talwar]

Would you be able to share a sample file to check it out?