6 Replies Latest reply: Aug 26, 2018 5:57 PM by Juzer Saifuddin RSS

    Daily running total for each month

    Juzer Saifuddin

      Hello,

       

      I would like to have a running total on daily basis for each month.

        

       

      2018-01-01978.29978.29
      2018-01-021516.322494.61
      2018-01-031524.514019.12
      2018-01-041633.255652.37
      2018-01-052265.947918.31
      2018-01-061792.149710.45
      2018-01-071983.2511693.7
      2018-01-082697.4814391.18
      2018-01-092681.0517072.23
      2018-01-102584.8119657.04
      2018-01-112519.4922176.53
      2018-01-122360.5124537.04
      2018-01-132021.5726558.61
      2018-01-142125.6828684.29
      2018-01-152528.1431212.43
      2018-01-162744.9333957.36
      2018-01-172759.9936717.35
      2018-01-182672.5239389.87
      2018-01-192520.7641910.63
      2018-01-202111.1244021.75
      2018-01-212326.8946348.64
      2018-01-222794.6649143.3
      2018-01-232863.1152006.41
      2018-01-242707.1954713.6
      2018-01-252847.2957560.89
      2018-01-262855.9660416.85
      2018-01-272350.662767.45
      2018-01-282345.9465113.39
      2018-01-29281367926.39
      2018-01-303034.9270961.31
      2018-01-312743.3173704.62
      2018-02-012399.252399.25
      2018-02-021790.34189.55
      2018-02-031482.11

      5671.66

       

      As you see that the running total is reset at the start of February.

      I want to implement this.

      I am currently using this expression which provides me cumulative sum from January to August

      rangesum(above(total sum(Spend),0,NoOfDays))


      Looking forward to your response.

      Thank you in advance