Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
=Count({<Mois_enquete_calcul={"$(=Date(Max(Mois_enquete_calcul)-1, 'MMM-YYYY'))"},Q11={'OUI'}>}Q11)
try this
=Count({<Mois_enquete_calcul={"$(=Date(Max(Mois_enquete_calcul)-1, 'MMM-YYYY'))"},Q11={'OUI'}>}Q11)
If you are looking for previous month, try like:
=Count({<Mois_enquete_calcul={"$(=Date(Addmonths(Max(Mois_enquete_calcul),-1), 'MMM-YYYY'))"},Q11={'OUI'}>}Q11)
Thanks Kush.
It works.
Kind Regards,
Hasvine