Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Here is my expression
It was working fine until i add the PreviousMonth variable in there.
PreviousMonth= Oct 2017
For some reason when i do $(vPreviousMonth) then result is ).
That the reason its not equating to the MonthYear Field.
Any thoughts? Is my expression correct.
i just want to filter the data to be to last Month
Thanks
Nithin
Try it without the $
In set analysis can we equate with expression without $?
Hi,
check if the date format are the same in the variable and in the dimension.
Formats are perfect but. i tried equating out side with just if case and it worked. Its not working Set analysis
How about this
ProvEst_CreatYearMonth = {'$(=vPreviousMonth)'}
Its still not working
What do you get when you use this in a text box object? (without dollar sign expansion)
=vPreviousMonth