Model builders can set a single calendar type for a model, but different timescales can also be set for modules and line items within the model.
Available time scales depend on the calendar type you select for a model.
|Available time scales
Not Applicable, Day, Month, Quarter, Half-Year, Year.
Note: Quarter, and Half-Year options are available if the Include: Quarter Totals, or Half-Year Totals options are selected in the Model Calendar.
|Weeks: 13 4-week Periods
|Not Applicable, Day, Week, Month, Quarter*, Year
Note: Quarter is available if the Include: Quarter Totals option is selected in the Model Calendar.
|Weeks: 4-4-5, 4-5-4 or 5-4-4
Not Applicable, Day, Week, Month, Quarter*, Half-Year*, Year
Note: Quarter and Half-Year options are available if the Include: Quarter Totals, or Half-Year Totals options are selected in the Model Calendar.
|Not Applicable, Day, Week
When line items in a module have different time scales, subsidiary views are created.
Where two line items each use a different timescale, and one refers to the other in a formula, then days aggregate into months, months aggregate into quarters, and quarters aggregate into years. You can also choose to skip levels. For example, days can aggregate into years.
If line item X has a time scale of months, and line item Y has a time scale of years, then Y=X returns the year total. However, X=Y returns nothing, because Y does not contain a corresponding value for each month.
You can set up formulas that use the WEEKVALUE, MONTHVALUE, QUARTERVALUE, YEARVALUE, or SELECT functions to return the results that you need. For example, if line item X is in months, and line item Y is in years:
Y = X
|Result takes the relevant time total from X, where X has a more detailed time scale than Y, such as X in months, Y in years.
X = Y
|Shows a blank, unless the summary method is set to Formula, in which case it shows the value Y in the year totals only.
X = YEARVALUE(Y) * Seasonality %
|Allocates Y according to a seasonality percentage.
X = Y[SELECT:Time.FY11]
|Shows the value of Y for a specific year.