Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
Refer attached sample application.
Regards!
Rahul Pawar
Hi ,
why it is not working without using 'Total'.Could please explain which scenarios we need to use 'Total'
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
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))).
hi Deva,
one more clip or result