topic How to Calculate Cumulative Sum in the Script ? in App Development

How to Calculate Cumulative Sum in the Script ?

Xabinav — Mon, 12 Aug 2019 11:59:47 GMT

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

Re: How to Calculate Cumulative Sum in the Script ?

Ezirraffner — Mon, 12 Aug 2019 12:38:42 GMT

Hi @Xabinav,

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

Re: How to Calculate Cumulative Sum in the Script ?

Xabinav — Mon, 12 Aug 2019 12:44:56 GMT

Thanks !!!