Set Analysis expression issue

[#1]

Hi all,

This is my expression:

=sum({1<Month={$(vMaxDate)}>} [Subscriber Count])

vMaxDate has a value (a date).

when I filter by regular selection I see a value under the next expression: =sum([Subscriber Count])

but I'm trying the set analysis to fix this calculation to the max Date and I get 0.

why can it be?

Thanks,

Boris

[#2]

the value of the variable is right. so the peek is correct

[#3]

doesn't work

[#4]

there is no data on the 12/1/2013 - unless its due to demo data?

[#5]

Try this demo, it is full with data, with 2 objects, one with regular selection and one with the set analysis.

[#6]

try this:

=sum({<Month={"=$(=Date(Max(Month)))"}>} [Subscriber Count])

[jagan]

Hi,

Use this expression, you are using wrong variable.

=sum({1<Month={'$(vMaxMonth)'}>}[Subscriber Count])

Regards,

Jagan.

[#8 · Accepted solution]

Sorry, Thanks!

[#9]

haha plus 1 - Didnt see that