3 Replies Latest reply: Mar 24, 2016 3:55 AM by Hasvine Dhurmea RSS

    Month- 1 expression

      Hello All,


      I am trying to calculate the month of my selection minus 1 month and I am using the expression below:


      =Count({<Mois_enquete_calcul={"$(=Date(Max(Mois_enquete_calcul), 'MMM-YYYY')-1)"},Q11={'OUI'}>}Q11)


      I think I am missing something as it is giving me 0 which is the wrong figure.


      Any idea?


      Many Thanks,