12 Replies Latest reply: Jun 5, 2014 2:39 AM by Fanie Becker RSS

    rolling 3 month average for past 6 months


      Hi

       

      I need to calculate the rolling 3 month average for a key performance indicator.

       

      1. In the expression, how do I select the current month and months -1, ... -6;

      2. How do I calculate the rolling avg for these months.

       

      Will appreciate

       

      Fanie