Cumulative Calculation Error

[#1]

Hi All,

I am using following formula to get cumulative over the period. I have MonthlySaving field and I want to get running sum each month or filter by any period (Quarter/Year from my calendar date).

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

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.

[#2]

can I inbox you sample data? I am not allowed to public data. However I found a surprise in my expression for VRMontlySaving. I produced result in excel and VRMontlySaving doen't get populated as a result of expression properly. But it gives me monthly result properly in chart as I showed you in clip. I think that's why it doesnot give me running sum properly. here is my expression. It seems due to null(empty cells) in data the expression don't give results as I saw in excel file. I am attaching

load *,
(Gast*CostGast)+(Respirology*CostRespirology)+(Neurology*CostNeurology)
+(Endocrinology*CostEndocrinology)+(Rheumatology*CostRheumatology)
+(Hepatology*CostHepatology)as VRMonthlySaving

FROM $(VQVDPath)Reporting.qvd](qvd);
store Reporting into $(VQVDPath)Reporting.csv(txt) ; //store in excel to see results