Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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