Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have 4-5-4 retail calendar, how to convert this calendar to normal calendar?
Thanks,
Hi,
I hope some one has worked on this scenario, can you please help me here.
Thanks,
Try this solution
The specific of the 4-5-4 calendar is that it uses retail periods, more or less approximate to months, with length of 4 weeks, 5 weeks, and 4 weeks in each retail quarter. So, you need to use "normal" months and quarters instead of the retail periods. If you have Date field, the Month-Year will be:
Date(monthstart(Date), 'MMM-YYYY') as MonthYear
Quarter:
'Q' & ceil(month(Date)/3) & '-' & year(Date)
This one: 4-5-4 Master Calendar is the opposite and I think you could reverse the logic and/or use them as mapping to your calendar.
- Marcus
Hi,
Thanks for your valuable posts, I got it.
Thanks,