Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
You could try this
sum({<Trans_Date_YYYY={'2018'},Trans_Date_M ={"<=$(=12)"}>} Amount)
Thanks,
Shreya
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?
Can you try this :
=sum({<Trans_Date_YYYY={'2018'}, Trans_Date_M-={"12"}>}Value)