Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SUM({<[Date.autoCalendar.InYTD]={1},[Date.autoCalendar.YearsAgo]={1} [Sales])
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])