set analysis - expression in Identifier

[Anonymous]

Hi guys,

this expression isn't working, can you give me a hint on what is wrong? The problem is in the identifier where I need to extract the year of dimension ASS_DTA_MAKEDATE (format 'MM/YYYY')

sum({<year(ASS_DTA_MAKEDATE)= {'$(=Date(yearname(today()),'YYYY'))'}>}, ASS_DBL_RN)

Thanks,

n

[MK_QSL]

You need to create below field in script itself.

year(ASS_DTA_MAKEDATE) as Year

now use as below

sum({<year= {'$(=Year(Today()))'}>}, ASS_DBL_RN)

[simondachstr]

Your expression has a , before the field - remove that.

Try the below:

sum({<ASS_DTA_MAKEDATE={"=Year(ASS_DTA_MAKEDATE) = $(=Date(yearname(today()),'YYYY'))"}>} ASS_DBL_RN)

[#4]

Hi Niccolo,

If you absolutely have to do this without creating any new fields, then the below should work for you. However I would recommend creating a new year field and using that as per Manish's suggestion

Sum({<ASS_DTA_MAKEDATE= {">=$(=YearStart(today())) <=$(=YearEnd(today()))"}>} ASS_DBL_RN)

Hope that helps

Joe