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

    Month- 1 expression

    Hasvine Dhurmea

      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,

       

      Hasvine