4 Replies Latest reply: Jan 23, 2017 8:36 AM by Andrey Khoronenko RSS

    Cummulating in Scrip with one Month value missing

    Manish Kumar

      Hi

       

      I have a data with some valued on monthly basis. But for one month value is not there.

      Thus when I cummulate the data in script it omits the row for the month which is not having the data. I need the cummulative value for that month also which is not having the value itself.

       

      Original data

       

      MonthValues
      01-04-201580615
      01-05-201574193
      01-06-201574193
      01-07-201574193
      01-08-201574193
      01-09-201574193
      01-10-201578336
      01-11-201574193
      01-12-201574193
      01-01-201674893
      01-03-2016

      8357

       

      Desired result

        

      MonthCummuative Values
      01-04-201580615
      01-05-2015154808
      01-06-2015229001
      01-07-2015303194
      01-08-2015377387
      01-09-2015451580
      01-10-2015529916
      01-11-2015604109
      01-12-2015678302
      01-01-2016753195
      01-02-2016753195
      01-03-2016761552