Simple set analysis with less than

[yipchunyu]

Just want to prepare an expression to sum up the value for 2018 Jan-Nov.

There are some fields with the data 

Trans_Date_M = 1,2,3,4,5,6 ....

Trans_Date_MM = 01,02,03,04 ....

Tried several ways but not ok.

sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={'<= 12'}>} Amount)

sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={*} - {12}>} Amount)

Any help?

[shreya_nadkarni]

Hi,

You could try this

sum({<Trans_Date_YYYY={'2018'},Trans_Date_M ={"<=$(=12)"}>} Amount)

Thanks,

Shreya

[jonathandienst]

That would include December. Try this:
sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={"<12"}>} Amount)

[yipchunyu]

Sorry, tried but not work for me.
Total
sum(USD)
Jan -Nov
sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={"<=$(=12)"}>} USD)
Dec
sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M={"=$(=12)"}>} USD)

All shows the same no when I select 2018.
Any idea?

[punitpopli]

Can you try this : 

=sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M-={"12"}>}Value)

[yipchunyu]

Seems incorrect in syntax check.