Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am aware of passing variables in expression when i give = in variable declaration
In Variable declaration
vMaxDate
=Max(Month)
Eg1----- =If(Month>Date(AddMonths(vMaxDate,-12),'YYYY-MM') and YTD>0,DateMonth)
Eg2----- =Num(Sum({<Region={'Global'},Month ={">$(=Date(AddMonths(vMaxDate,-12),'YYYY-MM')) <=$(vMaxDate)"}>} YTD), '##.##')
Eg3----- ==Num(Sum({<Function={'XXXXX'},Month={'$(vMaxDate)'}>}YTD),'##.00')
Now my Question is how to write whe i have not included = symbol in variable declarartion
vMaxDate
Max(Month)
Thanks in advance
Perhaps these?
If(Month>Date(AddMonths($(=vMaxDate),-12),'YYYY-MM') and YTD>0,DateMonth)
Num(Sum({<Region={'Global'},Month ={">$(=Date(AddMonths($(=vMaxDate),-12),'YYYY-MM')) <=$(=vMaxDate)"}>} YTD), '##.##')
Num(Sum({<Function={'XXXXX'},Month={'$(=vMaxDate)'}>}YTD),'##.00')
I have tried this but not working