2 Replies Latest reply: Oct 17, 2018 1:33 AM by Kenji Khoo RSS

    Last Year MTD show 0 when year filter selected.

    louis lam

      Hi all,

       

      I have applied below expression for Last Year MTD.

      It works fine when no filter is applied or Month / Date filter is applied.

      But when i select Year filter, it only show 0.

       

      Sum({<[SALES.SALES_DATE.autoCalendar.fYear2] =,[SALES.SALES_DATE.autoCalendar.Month]=,SALES.SALES_DATE = ,[SALES.SALES_DATE.autoCalendar.DateNum]={">=$(=Num(AddYears(MonthStart(max([SALES.SALES_DATE.autoCalendar.DateNum])),-1))) <=$(=Num(AddYears(max([SALES.SALES_DATE.autoCalendar.DateNum]),-1)))"} >} [SALES.SALES_AMOUNT])

       

      Any idea?

       

      Best Regards,

      Louis