10 Replies Latest reply on May 11, 2018 7:25 AM by Rajesh Narasimha Murthy

    6months rolling average calculation

    Rajesh Narasimha Murthy

      Hi

       

      I am looking for the calculated field showing the 15 months rolling average.

       

      I have calculated value called  STP% with formula "SUM(IIF([type_auto]="STP" ,[COUNT],0))/  SUM([COUNT]". this gives the STP%.

      if I bring months and drag stp%, I get the values correctly.

       

      what I am looking at is, I want to get the rolling 6 months average of the percentages of STP% which I already calculated.

      Example:

      with the below table I want to see the last rolling six months of average of the STP% calculated.

      Example: rolling six months average of STP% from Dec 2017 to May 2018 is 68.03%. like this I am looking for a dynamic rolling 6 months calculation. kindly help.

       

       

      MonthsSTP%
      Oct-201769.87%
      Nov-201768.48%
      Dec-201766.20%
      Jan-201870.22%
      Feb-201867.19%
      Mar-201866.87%
      Apr-201865.64%
      May-201872.07%