# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Cumulative Calculation

Hi All,

I have following fields. I need to calculate Cumulative amount. I have fiscal period and monthly saving fields. please help.

I use rangesum(above(sum([VRMonthlySaving]),0,rowno())) but not working. give 0's or wrong figure against wrong month. Thanks

 Fiscal Period Monthly Savings Cumulative 1-Dec-14 4180 4180 1-Jan-15 4180 8360 1-Feb-15 1330 9690 1-Mar-15 3040 12730 1-Apr-15 2850 15580 1-May-15 3420 19000 1-Jun-15 5130 24130 1-Jul-15 5130 29260
6 Replies
Honored Contributor II

## Re: Cumulative Calculation

Hi,

Try like below

Create Expression as Cumulative Savings

and enable [Fiscal period] sorting  as ascending order

=RangeSum(Above(TOTAL Sum([Monthly Savings]), 0, RowNo(TOTAL)))

PS: also you can achieve by using as of Table method (back end script method)

Hope this helps to you

Regards,Deva

Valued Contributor II

## Re: Cumulative Calculation

Refer attached sample application.

Regards!

Rahul Pawar

Not applicable

## Re: Cumulative Calculation

Hi ,

why it is not working without using 'Total'.Could please explain which scenarios we need to use 'Total'

Honored Contributor II

## Re: Cumulative Calculation

Hi,

Without "Total" it will just show the row actual value. so we need to use TOTAL qualifier to read the whole column

That will sum up all the amounts in the first column (corresponding to the first visible expression in Chart).

Thanks,

Deva

Not applicable

## Re: Cumulative Calculation

Hi Deva,

Thanks for your solution. Actually when I tried it on my data it gave me 0's and the values started from mar-2017 but wrong. I am using derived Year/Month from date. It gives me calculation for MonthlySaving properly by month as shown in graph and table. But I am unable to get cumulative. Where I am wrong.? I used the same formula

RangeSum(Above(TOTAL Sum([VRMonthlySaving]), 0, RowNo(TOTAL))).

Not applicable

## Re: Cumulative Calculation

hi Deva,

one more clip or result