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:




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