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]

Hi Boris,

The syntax seem OK but:

1) check that the variable contains a valid Month

2) check that the value does not contain any blank or any specific character. If so, you must enclose your variable between brackets: []

=> [$(variable)]

Fabrice

[#3]

if your vriable contains a date try this:

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

when your variable contains a string you need to enclose your variables - otherwise it wont work. It only works with int datatypes.

And moreover be sure you use the correct datefield. Maybe it should be your datefield instead of Month?

[#4]

Still doesn't work.

[#5]

can u post ur document sample?

[#6]

hi

try this

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

[#7]

can you that variable which is given by you

vMaxDate=

[#8]

Hi, attached is the sample that doesn't work

[#9]

try this

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

[#10]

first of all ur peek is wrong i think

try this:

let vMaxMonth=peek ('Month',-1,'MAX_Month');

As i can see your max month is 12/1/2013 - I dont know if this is due to sample data. But beaware of this..