Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load script or front end?
Hi Lanie,
PLease see attached.
Thanks,
Richard
hi richard,
I would like to do this as a script rather ...
thanks
load script please...
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
];