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.