2 Replies Latest reply: Apr 11, 2014 5:04 PM by Manish Kachhia RSS

    weekend in Master Calendar

      We have volume in Saturday and Sunday. But we want to add saturday volume to friday and sunday volume to monday.

      How do we change master calendar for this requirement? We don't want to change anything on the database table.we prefer Changes in the master calendar .

        • Re: weekend in Master Calendar
          Juan Navarro

          If you only need to fool the system I would add a column in your master calendar with tha new value that you need to point, then use it instead of the old one, so you calendar would look like this:

           

          KeyDayNew Day
          11/04/2014FridayFriday
          12/04/2014SaturdayFriday
          13/04/2014Sunday

          Monday

           

          Of course you can change the labels so the new column be the old one, I'm trying to understand what you need and this is what occurs to me but if not please let me know.

          • Re: weekend in Master Calendar
            Manish Kachhia

            You can create a DayFlag in your master calendar script..

             

            IF(WeekDay(Date) = 5, Dual('Fri',4), IF(WeekDay(Date) = 6, Dual('Mon',0), Dual(WeekDay(Date),WeekDay(Date)))) as DayFlag