10 Replies Latest reply: Aug 11, 2017 12:13 PM by Saima SM RSS

    Cumulative Calculation Error

    Saima SM

      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.untitled.png