set analysis expression

[#1]

is this set expression is fine??

sum({$<Year = {$(vCurrentYear)},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Thanks

[SunilChauhan]

what is the problem with your expression.is it not working  or just verifying

check with  below points

1) as per Jagan's suggestion put 2014 and check wither your variable working fine

2) weither data available for Current Year  in Raw data

3) try to put  $(vCurrentYear) inside "" like " $(vCurrentYear)" in expression

4)see my suggestion above i mean Use =Year(today()) in place of variable

5)  select Year from List box year and then check its working then try to use below

sum({<Year = {$(vCurrentYear)},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

6) check weither data available for combination Current Year and 3. Due Later

hope this helps

[#3]

Hi,

sum({$<Year = {'$=(vCurrentYear)'},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

[#4]

Hi,

Try like below:

sum({$<Year = {'$(=$(vCurrentYear))'},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])