4 Replies Latest reply on Aug 27, 2013 2:09 PM by Jonathan Drummey

    How do you create a MTD and YTD filter or calculation for a retail (454) calendar?

    Monica Vela

      I am using this filter on the [DAY NUM IN MERCH WEEK] field to get WTD information for TY and LY, and it seems to be working.

       

      MAX([DT] )<today() and MAX([DT] ) >= DATETRUNC('week', today())

       

      What filter can I use to get MTD and YTD information, defining the first day of the month or year, following the NRF 454 calendar?

       

      I can't attach my file because of security, but I do have the following fields available:

      CAL MONTH NUM

      DAY NUM IN MERCH MONTH

      DAY NUM IN MERCH WEEK

      DAY NUM IN MERCH YEAR

      MERCH YEAR

      MERCH QUARTER

      MONTH NUM IN MERCH YEAR

      WEEK NUM IN MERCH YEAR

      DT (DATE)