6 Replies Latest reply: Aug 10, 2017 11:35 AM by Saima SM RSS

    Cumulative Calculation

    Saima SM

      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 PeriodMonthly SavingsCumulative
      1-Dec-1441804180
      1-Jan-1541808360
      1-Feb-1513309690
      1-Mar-15304012730
      1-Apr-15285015580
      1-May-15342019000
      1-Jun-15513024130
      1-Jul-15513029260