1. Modeling
2. Dimensions
3. Time
4. Model Calendar
5. Use Mixed Timescales

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.