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:
- Select Modules in the model settings bar.
- Select the module that contains the line item you want to edit, then select Open.
- Select Blueprint .
- 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:
In the table below, the X
and Y
line items have the same time scales as above.
Example formulas | Explanation |
Y=X | The formula returns the relevant time total from X , where X has a more detailed timescale than Y . |
X=Y | The formula returns a blank result, unless the Summary method is set to Formula, in which case it will show the value Y in the year totals only. |
X=YEARVALUE(Y) | The formula returns the value of Y in each month. |
X=YEARVALUE(Y)/12 | The formula evenly allocates the value of Y over months. |
X=YEARVALUE(Y) * Seasonality % | The formula allocates Y according to a seasonality percentage. |
X=Y[SELECT:Time.FY11] | The formula returns the value of Y for a specific year. |