Trouble with YTD

Anonymous — Wed, 06 Jul 2016 19:48:10 GMT

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

Re: Trouble with YTD

sunny_talwar — Wed, 06 Jul 2016 19:52:53 GMT

May be this:

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