Autocalendar | Previous YTD

[fosterma]

Hello all,

I'm tying to achieve a Previous YTD measure using autocalendar. Is this possible?

I'm using the below, but the incorrect result is returned (0).

SUM({<[Date.autoCalendar.InYTD]={1},[Date.autoCalendar.YearsAgo]={1} [Sales])

Thanks

[sunny_talwar]

What does your derived calendar script look like? Is it assigning 1 for true or -1?

If it is -1, then try this

Sum({<[Date.autoCalendar.InYTD]={'-1'},[Date.autoCalendar.YearsAgo]={'-1'} [Sales])