2 Replies Latest reply: Jul 4, 2018 11:44 AM by Aaron Dhobi RSS

    This month 12 months ago

    Aaron Dhobi

      HI Guys,

       

      Hoping you could help me.

       

      I want to avg(sales) for the current month 12 months ago so July 2017

       

      I already have a current month flag field which returns 1 or 0,  (today's month- July 2018.)

       

      I want to get the avg(sales) for the current month, 12 months ago.

       

      I have already tried this but its not working:

       

      AVG({<MonthYear={"$(=Monthname(addmonths(Max(MonthYear),-12)))"}>}Sales)

       

      Could i please request to try do this in the front end if possible

       

      Thanks,

      Aaron