22 Replies Latest reply: Jul 27, 2017 7:03 AM by Sada Siva RSS

    How to get average of Cumilative sum values

    Sada Siva

      Hi Team,

       

      I am having numbers need to be added as cumilatively. Range sum() will do that. After that i need to get average of those numbers monthly. I am having 5 years of data.

       

      For example

         In this case if i want to calculate Avg for May-17 i need to consider (72+102)/2 insted of (12+30)/2

       

      monthyearValueRange sum
      Jan-171515
      Feb-172035
      Mar-172560
      Apr-171272
      May-1730

      102

       

       

      How can i achieve this. Thanks in advance.

       

      Regards,

      Sadasiva