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 ?