Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm having an issue with calculating a YTD sum of a value. Is there something I'm missing in my expression?
Sum({<CALENDAR.YEAR_DASH_MONTH= {">=$(=Date(max([CALENDAR.YEAR_START]),'YYYY-MM'))<=$(=date(Today(),'YYYY-MM'))"}>}ACTUALS)
The YEAR_DASH_MONTH field is in a YYYY-MM format by default, the other date fields are not in that format.
Thank you in advance
May be this:
Sum({<CALENDAR.YEAR_DASH_MONTH= {">=$(=Date(YearStart(Today()),'YYYY-MM'))<=$(=date(Today(),'YYYY-MM'))"}>}ACTUALS)