Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Can you show screenshots please
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)
What luna field holding? Is that a Month, If so what format it is?
i have data, in it, and if i truy whithout addmonth it works, the problem is with addmonths, or maybe the data type
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?