Previous' Month Value Issue

[#1]

Hello,

I'm trying to get a result from the previous month. No sucess so far. Here's the expression:

count({$<ANO_MES={$(v_mes_anterior)}>}ID)

• ANO_MES is the month's name: Jan/14,Feb/14...
• v_mes_anterior is the variable that reveals the previouos month: =(Date(addmonths(Max(ANO_MES), -1),'MMM/YY'))
• ID: dimension that I'm using

When I use the first expression above all can I get it's a null value. Can someone help me to solve this?

Thanks!

[MK_QSL · Accepted solution]

have you tried?

count({$<ANO_MES={"$(=v_mes_anterior)"}>}ID)

or

count({$<ANO_MES={'$(=v_mes_anterior)'}>}ID)

[#3]

Try this:

=Count({<ANO_MES={"$(=v_mes_anterior )"}>} ID)

[maxgro]

you can try with (add ' ' to your expression)

=count({$<ANO_MES={'$(v_mes_anterior)'}>}ID)

[its_anandrjs]

You can also try with

count({ <ANO_MES={' $(=(Date(addmonths(Max(ANO_MES), -1),'MMM/YY'))) '}>}ID)

[#6]

Yes! It worked. Thanks a lot, Manish, Massimo and Padmaja!