Cumulative Sum

[#1]

Hi Need help for the formula to get the following results (last column should be cumulative sum of the 2nd column)

JML Month	Exits	Cumulative Exit
2015/05/31	1	1
2015/06/30	2	3
2015/08/31	6	9
2015/09/30	58	67

Basically I need the formula for Cumulative exit

thanks in advance

regards,

Lanie

[jonathandienst]

Load script or front end?

[#3]

Hi Lanie,

PLease see attached.

Thanks,

Richard

[#4]

hi richard,

I would like to do this as a script rather ...

thanks

[#5]

load script please...

[settu_periasamy]

Try this

Cum:

Load [JML Month], Exits, RangeSum(Exits,Peek(Cumulative_Exit)) as Cumulative_Exit;

LOAD * INLINE [

     JML Month, Exits

    2015/05/31, 1

    2015/06/30, 2

    2015/08/31, 6

    2015/09/30, 58

    ];