set analysis month(addmonths(today(),-x))

[cristian]

Hello

Why this expresion is working 

sum({<luna={"$(=(month((today()))))"},an={"$(=year(addmonths(today(),-3)))"},lit_doc={'B'}>}cant)

but this does not 

sum({<luna={"$(=(month(addmonths(today(),-3))))"},an={"$(=year(addmonths(today(),-3)))"},lit_doc={'B'}>}cant)

[pradosh_thakur]

Can you show screenshots please

[lorenzoconforti]

Maybe you need to remove the addmonths from the first expression? Maybe you don't have data for that specific month/year combination. It would be easier to help you if you could provide more info

=sum({<luna={"$(=(month((today()))))"},an={"$(=year((today())))"},lit_doc={'B'}>}cant)

but this does not

sum({<luna={"$(=(month(addmonths(today(),-3))))"},an={"$(=year(addmonths(today(),-3)))"},lit_doc={'B'}>}cant)

[Anil_Babu_Samineni]

What luna field holding? Is that a Month, If so what format it is?

[cristian]

i try in wo different way
originally luna was a substring and it looks something like '07' for june and '11' for november, i saw that for the year there is no problem and the expresion is working
i try also to make a numeric luna field, like this, round(val(substr(nr_ies,9,2)),0) as lunan, but this does not work either. I assume that is a data compatibilitlity problem, but i don;t know where to look.

[cristian]

i have data, in it, and if i truy whithout addmonth it works, the problem is with addmonths, or maybe the data type 

[cristian]

hello

i think the problem is that my variable luna is in form of nn.00   i mean something like 11.00, and the month(addmonths(date())) return only nn, meaning  11 and it think tha 11 is different from 11.00.

is there a wat to make him understand that 11 is equal to 11.00?