Cumalative/running total

[asinghal0412]

Dear Qlik Community,

I have a table below,

Calendar Year/Month	New & Carryover	Net VAVE (Calculated)	Cummalative Net Vave
Jan 2021 Actual	single : Carryover	373 M¥	0
Jan 2021 Actual	single : New	64 M¥	0
Feb 2021 Actual	single : Carryover	359 M¥	0
Feb 2021 Actual	single : New	78 M¥	0
Mar 2021 Actual	single : Carryover	358 M¥	0
Mar 2021 Actual	single : New	161 M¥	0
Apr 2021 Actual	single : Carryover	365 M¥	0
Apr 2021 Actual	single : New	155 M¥	0
May 2021 Forecast	single : Carryover	80 M¥	0
May 2021 Forecast	single : New	122 M¥	0
Jun 2021 Forecast	single : Carryover	72 M¥	0
Jun 2021 Forecast	single : New	155 M¥	0
Jul 2021 Forecast	single : Carryover	63 M¥	0
Jul 2021 Forecast	single : New	179 M¥	0
Aug 2021 Forecast	single : Carryover	58 M¥	0
Aug 2021 Forecast	single : New	149 M¥	0
Sep 2021 Forecast	single : Carryover	44 M¥	0
Sep 2021 Forecast	single : New	198 M¥	0
Oct 2021 Forecast	single : Carryover	29 M¥	0
Oct 2021 Forecast	single : New	203 M¥	0
Nov 2021 Forecast	single : Carryover	11 M¥	0
Nov 2021 Forecast	single : New	224 M¥	0
Dec 2021 Forecast	single : Carryover	0 M¥	0
Dec 2021 Forecast	single : New	207 M¥	0

In the last column, I am trying to get the cumulative total of the 3rd column.

My current code is:

RangeSum(Above(TOTAL Sum([Net VAVE (Calculated)]), 1, RowNo(TOTAL)))

but as you can see in the table the values are zero.

Can any1 help me with the code?

Thanks,

Akash

[MayilVahanan]

Hi @asinghal0412

Try like below

RangeSum(Above(Total Sum([Net VAVE (Calculated)]),0, RowNo(Total)))

o/p:

[asinghal0412]

I tried your code, It gives an error message.

Did you change the 3rd column as well?

Akash

[MayilVahanan]

HI @asinghal0412 

Instead of "Sum([Net VAVE (Calculated)])", you can change use ur expression. 

If it still shows error, pls provide the sample file