calculate cumulative sales for two expression

[sakshikaul]

Hi

I have written expression to calculate cummulative sales as follows:-

=num(sum({<Sold_Date = {">=$(From)<=$(To)"} >}[inv value]/Sales_INR_Unit))

but don't know if i have to deal with two expressions

=RangeSum(Above( Sum([sales price]* quantity_sold)) and [sales price]* quantity_sold, 0, RowNo())

this is giving wrong result.

please help

[jyothish8807]

Hi Sakshi,

Can you please explain your requirement a bit more ? It is not clear to me as of now.

You can write the 2nd exp like this, why are you using an "and" in between ?

=RangeSum(Above( Sum([sales price]* quantity_sold)) , 0, RowNo())

Br,

KC

[sakshikaul]

This expression is working

=RangeSum(Above(total Sum([sales price]* quantity_sold)+sum([sales price]* quantity_returns), 0, RowNo(total)))

[jyothish8807]

Hi,

Please close the thread if you have got the solution.

Br,

KC