Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
Have some problem with calculation cumulative sum from below.
There is neccessary result in attached example
i calculate cumulative sum from top by:
rangesum(Above(sum(sales),0,rowno()))
but don't know how to calculate cum sum from below
Thanks for all advices!
Hi,
Please find attached file for solution, wrong expression name in the set analysis earlier.
Regards,
Jagan.
Instead of Above() use it's counter part Below().
Or
Use Above() with negetive offset. Like : =Above(Sum(Sales), -2,0)
Try with
From above
Rangesum(Above( Sum(sales) ),0, Rowno() )
and for Below or reverse accumulation
Rangesum(Below( Sum(sales) ),0, Rowno() )
Hi,
Please find attached file for solution.
Regards,
Jagan.
is your example correct?
i need to show cum sum for each value from below.
In you file you calculate only total cum sum
and you calculate only two values every time- previous and next.. i think it's not cum sum
it's working some strangely...
from value 1/5/2014 calculation is not correct !
it's working some strangely...
from value 1/5/2014 calculation is not correct !
Hi,
Please find attached file for solution, wrong expression name in the set analysis earlier.
Regards,
Jagan.
it's what i need!
thank you!))