Set Analysis not working

[nithin_miryala]

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

[Anonymous]

Try it without the $

[nithin_miryala]

In set analysis can we equate with expression without $?

[YoussefBelloum]

Hi,

check if the date format are the same in the variable and in the dimension.

[nithin_miryala]

Formats are perfect but. i tried equating out side with just if case and it worked. Its not working Set analysis

[sunny_talwar · Accepted solution]

How about this

ProvEst_CreatYearMonth = {'$(=vPreviousMonth)'}

[nithin_miryala]

Its still not working

[sunny_talwar]

What do you get when you use this in a text box object? (without dollar sign expansion)

=vPreviousMonth