Cummulative

[#1]

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'..

[#2]

Hi

If you need that in chart you can use acummulation settings in chart preferences (Expressions tab).

Przemek

[#3]

No. I need that in table.

[jagan]

Hi,

If you are using Straight table try using the Full Accumulation in Expression tab.

Regards,

jagan.

[jagan]

Hi,

Hope the attached sample helps you.

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     Try with this expression.

     =Sum(Amount) + Alt(Above([Cummulative Amount]),0)

Celambarasan

[#7]

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()))