How to Calculate Cumulative Sum in the Script ?

[adimiz123]

Hello Everyone ,

I need help creating the cumulative Sum  column (in red) is script,  as shown in the table below.

How to write a script to get cumulative Sum column?

Thanks

ROW_NUM	ORDER_DATE	ORDER_AMOUNT	Cumulative Sum
1	23/02/2017	260	260
2	23/02/2017	100	360
3	25/06/2017	50	410
4	17/08/2017	495	905
5	17/08/2017	100	1005
6	24/10/2017	0	1005
7	24/10/2017	175	1180
8	17/01/2018	0	1180
9	18/01/2018	395	1575
10	24/01/2018	100	1675
11	13/02/2018	100	1775
12	12/03/2018	100	1875
13	18/04/2018	175	2050
14	10/05/2018	100	2150
15	10/05/2018	780	2930
16	10/05/2018	100	3030
17	29/05/2018	150	3180

[Ezir · Accepted solution]

Hi @adimiz123,

In load editor you can use RangeSum() and Peek(). 

TABLE:
LOAD ROW_NUM,ORDER_DATE, ORDER_AMOUNT, RangeSum(peek('Cumulative') , ORDER_AMOUNT) AS Cumulative INLINE [
ROW_NUM,	ORDER_DATE,	ORDER_AMOUNT,	
1,	23/02/2017,	260,
2,	23/02/2017,	100,
3,	25/06/2017,	50,
4,	17/08/2017,	495,
5,	17/08/2017,	100,
6,	24/10/2017,	0,
7,	24/10/2017,	175,
8,	17/01/2018,	0,
9,	18/01/2018,	395,
10,	24/01/2018,	100,
11,	13/02/2018,	100,
12,	12/03/2018,	100,
13,	18/04/2018,	175,
14,	10/05/2018,	100,
15,	10/05/2018,	780,
16,	10/05/2018,	100,
17,	29/05/2018,	150
];

I hope helps you.

Regards

Ezir

[adimiz123]

Thanks !!!