Difference between Calendar Type options - "Weeks"

Highlighted
New Contributor

Difference between Calendar Type options - "Weeks"

Hi 

Context :

In Model Calender, Calender Types reflects 3 different options like

a) Weeks: 4-4-5, 4-5-4 or 5-4-4

b) Weeks: General

c) Weeks: 13 4-week periods

 

In exl there is "weeknum" to interpret the week number in a given date. 

 

Appreciate a clarification on different week formats provided by default.

Cheers.

 

 

3 REPLIES 3
Highlighted
Community Boss

Re: Difference between Calendar Type options - "Weeks"

Hello @Augustus ,

 

Great question.

 

It is explained well here in Anapedia

 

Countries / Companies have several ways, standards and traditions, to report data in week, month, quarter and year.

 

For someone, calendar month and quarter is good.

 

For someone, they report by 4-4-5 quarters (4 weeks in the first month, 4 weeks in second and 5 weeks in the third). Typically every quarter will have 13 weeks. An year is not exactly 52 weeks, to compensate this you have a 14 week quarter once in every 5 or 6 years. Once you configure data by weeks, reporting it by calendar month needs additional effort. 4-4-5 fiscal month and calendar (Gregorian) month is not same.

 

General week is simply weeks without rolling upto quarters and months. You can map the general week to a custom quarter as defined by business. Only in general week, you have a model calendar that is less than a year. In all other options, you can add time to your model calendar in multiple of years only.

 

Based on requirements, the solution architect has to evaluate and choose the right setting for the model.

 

Thanks

Arun

 

 

 

 

Highlighted
New Contributor

Re: Difference between Calendar Type options - "Weeks"

Thanks mate.

I have another question in level 1 model building appreciate if you can assist me on it as well.

 

Highlighted
Community Boss

Re: Difference between Calendar Type options - "Weeks"

Sure, let me know your question or give me the link if you had already asked in Level 1 forum

 

Thanks

Arun