Variable References

How to reference a Variable in a Calculation

Creating a Variable Reference

Most references to Variables are created in one of two ways:

Screenshot showing two ways of adding a reference to a Variable in a Calculation. One through the dropdown, and one through the Add Variable Reference button.
Adding a Variable Reference
  1. From the Formula Entry Bar, by typing a name and selecting the relevant Variable from the dropdown list (1).

  2. Clicking on the Add Variable Reference button at the bottom of the list of Calculation Parts (2).

The first option is great when you know the name of the Variable you want to reference, and can access it quickly via a simple text search.

The second option is useful when you are unsure of the name, and want to browse through the full list of Variables, or for when you want to see a list of Variables that match the Remaining Unit.

When you enter a Variable using one of these methods, the default behaviour is:

  • The current period will be referenced

  • If the referenced Variable has Dimensions, Models will make its best evaluation of which item(s) should be referenced, depending on the source Variable

If the default behaviour is not desired, you can configure the reference in detail to your requirements. The following sections explain the ways in which you can do this.

Last updated