Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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:
Key | Day | New Day |
11/04/2014 | Friday | Friday |
12/04/2014 | Saturday | Friday |
13/04/2014 | Sunday | 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.
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