Set Anlaysis issue

Karthik3 — Mon, 10 Aug 2015 13:25:56 GMT

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?

Re: Set Anlaysis issue

MK_QSL — Mon, 10 Aug 2015 13:31:09 GMT

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])