Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help on cummulative.
Eg.
Amount | Cummulative Amount |
---|---|
1 | 1 |
2 | 3 |
3 | 6 |
4 | 10 |
5 | 15 |
Can anybody please tell the syntax to calculate 'Cummulative Amount'..
Hi
If you need that in chart you can use acummulation settings in chart preferences (Expressions tab).
Przemek
No. I need that in table.
Hi,
If you are using Straight table try using the Full Accumulation in Expression tab.
Regards,
jagan.
Hi,
Hope the attached sample helps you.
Regards,
Jagan.
Hi,
Try with this expression.
=Sum(Amount) + Alt(Above([Cummulative Amount]),0)
Celambarasan
This is the expression that I use in my Chart. I have Set analysis filtering a Cost type to Obligated, so its possible.
=RangeSum(above(Sum({$<[Cost Type]={"Obligated*"}>}Amount),0, rowno()))
No set analysis:
RangeSum(above(Sum(Amount),0, rowno()))