Set Anlaysis issue

[Karthik3]

Hi,

     I have declared the following as variable in script

LET vcurrent_year = 'IF(GETPOSSIBLECOUNT(Year)=1, Year, IF(MAX(Year)>=Year(TODAY()), YEAR(TODAY()), MAX(Year)))';

But when I use the variable in front end as

SUM({<Year={$(vcurrent_year)}>}[#Invoice Line EUR Value])

then it gives me an error

Error: Error in set modifier ad hoc element list:

',' or ')' expected

What am I doing wrong?

[MK_QSL]

Create a Variable as below in Variable Overview

vcurrent_year

IF(Max(Year)>Year(Today()),Year(Today()),Max(Year))

//without equal sign

Now use it as below

=SUM({<Year = {"$(=$(vcurrent_year))"}>}[#Invoice Line EUR Value])