Apply time scales to individual line items

You can set the time scale for either your entire model in Time in the model settings bar, or different time scales for line items in a module. For example, if the default dimension is measured by Year, you can create a line item that has a time scale of Month.

To apply a different time scale to an individual line item:

1. Select Modules in the model settings bar.
2. Select the module that contains the line item you want to edit, then select Open.
3. Select Blueprint .
4. Select an option for your chosen line item in the Time Scale column.

When you change the time scale for a line item, a subsidiary view is automatically created.

Formula example

If two line items have a different time scale, and one refers to the other in a formula:

• Days sum into months. 
• Months sum into quarters.
• Quarters sum into years. 

If required, you can skip different time levels. For example, days can sum 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 a blank value, as Y contains no corresponding value for each month (X).

You can create formulas with the following functions to return a result:

• WEEKVALUE
• MONTHVALUE
• QUARTERVALUE
• HALFYEARVALUE
• YEARVALUE
• SELECT

In the table below, the X and Y line items have the same time scales as above.