3 Replies Latest reply: Nov 8, 2016 12:44 PM by Robin Hausdörfer RSS

    Average over the past 3 months

    Laura Sébille

      Hey everyone,

       

      I have got the sales for each day since the beginning of the year.

       

      I would like to calculate the average sales per month over the last 3 months.

       

      I want to use a set analysis like :

       

      sum ({<[Month_year]= {[Month_year] > Addmonths( CurrentMonthYear,-3)}>}  [Sales])

       

      Of course, this syntaxe doesn't work. any idea ?