Set Analysis confusion

[adnan_rafiq]

Hi Experts.

I am having a weird experience with set analysis. Here are my expressions.

=sum({<MONTH={'01/02/2016'}>} DATA)

=sum({<MONTH={"=$(vL.AMaxMon)"}>} DATA)

where

=$(vL.AMaxMon) is max({<DATA_STATUS={'ACTUAL'}>}MONTH) which evaluates to  01/02/2016

That should be the same as sum({<MONTH={'01/02/2016'}>} DATA) but I see different results of sum.

Are there  limitations of some kind on set analysis.

I am showing this is text boxes. Can some one help??

[sunny_talwar · Accepted solution]

Can you try this:

=Sum({<MONTH={'$(=$(vL.AMaxMon))'}>} DATA)

or this

=Sum({<MONTH={'$(=vL.AMaxMon)'}>} DATA)

[adnan_rafiq]

Thanks for prompt suggestion Sunny

=Sum({<MONTH={'$(=vL.AMaxMon)'}>} DATA)

gives

Error: Error in set modifier ad hoc element list:

',' or ')' expected

But

=Sum({<MONTH={'$(=$(vL.AMaxMon))'}>} DATA)

works can you explain why?

[sunny_talwar]

I guess we need to use something that can replace 01/02/2016 in the set analysis. Whatever that thing is, need to be expanded using $(=...). My guess is that if you put $(vL.AMaxMon) in a text box, it would expand to this -> 01/02/2016.

So this is what I usually do. Whatever I need in my set analysis, I create that in the text box object and then copy the whole thing and paste it into my dollar sign expansion. Does that make sense?

[adnan_rafiq]

Thanks A Million stalwar1‌

[sunny_talwar]

Not a problem, I am glad I was able to help