Available time scales depend on the calendar type you select for a model.
Calendar type | Available time scales |
Calendar Months/Quarters/Years | 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. |
Weeks: General | Not Applicable, Day, Week |
When line items in a module have different time scales, subsidiary views are created.
Mixed time scales and formulas
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. |
Note: When you use a time-related calculation function, such as WEEKVALUE or MONTHVALUE, the value returned depends on the Summary method set for the source line item.