Variable in Set Analysis

[#1]

Guys,

I have a variable as follows:

vCurMonth=num(Month(Today()))

I want to use this variable within my expression in the table:

Sum({<Months={$(vCurMonth)}>}Allocations)

But it's not working.

Any ideas?

[jonathandienst]

Hi

Is your Months field numeric? The variable definition needs a leading = sign (in Variable Overview). So vCurMonth should be:

     =Month(Today())

     or

     =Num(Month(Today())

HTH

Jonathan

[#3]

Hi,

It works perfectly in calculated dimension, but this variable isnt working in Set Analysis in expression. I guess, there's no problem with formats