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