Trouble with YTD

[Anonymous]

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

[sunny_talwar]

May be this:

Sum({<CALENDAR.YEAR_DASH_MONTH= {">=$(=Date(YearStart(Today()),'YYYY-MM'))<=$(=date(Today(),'YYYY-MM'))"}>}ACTUALS)