Although a single calendar type is defined for a model in Model Settings > Time > Model Calendar, it is possible to have mixed timescales within a model. Each module and each line item can use its own timescale, however, the choice of timescale depends on the primary calendar type:
Calendar Type | Timescales Available |
Calendar Months/Quarters Years | Not Applicable, Day, Month, Quarter, Years |
Weeks: 4-4-5, 4-5-4 or 5-4-4 | Not Applicable, Day, Week, Month, Quarter, Years |
Weeks: General | Not Applicable, Day, Week |
Examples of Mixed Timescales
Where two line items each use a different timescale, and one refers to the other in a formula, then days will aggregate into months, months aggregate into quarters, and quarters aggregate into years. You can choose to skip levels: days can aggregate directly into years.
If line item X has a timescale of months and line item Y has a timescale of years, then Y=X will return the year total. However X=Y will return nothing because Y contains no corresponding value for each month. Formulas using the WEEKVALUE, MONTHVALUE, QUARTERVALUE, YEARVALUE or SELECT functions can be set up to return the result required. For example, if X is in months and Y is in years:
Y = X | Result takes the relevant time total from X, where X has a more detailed timescale than Y, such as X in months, Y in years. |
X = Y | Shows a blank, unless Summary method is set to Formula, in which case it will show the value Y in the year totals only. |
X = YEARVALUE(Y) | Will show the value of Y in each month. |
X = YEARVALUE(Y)/12 | Will allocate the value of Y evenly over months. |
X = YEARVALUE(Y) * Seasonality % | Will allocate Y according to a seasonality percentage. |
X = Y[SELECT:Time.FY11] | Will show the value of Y for a specific year |
Important When you use any of the time functions, such as WEEKVALUE or MONTHVALUE, the value returned depends on the Summary Method set for the source line item.