Month- 1 expression

[#1]

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

[Kushal_Chawda · Accepted solution]

try this

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

[tresesco]

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)

[#4]

Thanks Kush.

It works.

Kind Regards,

Hasvine