Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
When I use the first expression above all can I get it's a null value. Can someone help me to solve this?
Thanks!
have you tried?
count({$<ANO_MES={"$(=v_mes_anterior)"}>}ID)
or
count({$<ANO_MES={'$(=v_mes_anterior)'}>}ID)
have you tried?
count({$<ANO_MES={"$(=v_mes_anterior)"}>}ID)
or
count({$<ANO_MES={'$(=v_mes_anterior)'}>}ID)
Try this:
=Count({<ANO_MES={"$(=v_mes_anterior )"}>} ID)
you can try with (add ' ' to your expression)
=count({$<ANO_MES={'$(v_mes_anterior)'}>}ID)
You can also try with
count({ <ANO_MES={' $(=(Date(addmonths(Max(ANO_MES), -1),'MMM/YY'))) '}>}ID)
Yes! It worked. Thanks a lot, Manish, Massimo and Padmaja!