Skip to main content
Skip table of contents

Operations / Node Formulas

Use basic operations (+ - * /), and simple quotes around node names. Ex.: 'Income' - 'Expense'.

You can use all nodes from the model, and its submodels. Once you start typing a single quote ( ' ) the system shows a list of available nodes. You can connect them with the standard operations (* - * /) and the operations from below.

Operators can be nested, e.g. it is possible to use DISAGGREGATE(DISAGGREGATE('node',... ) ...)

Use the number sign (#) to write comments in a node.

Simple numbers are considered a 0-dimensional data point! That means that 'Node' + 1 will be calculated as "ROLLUP('Node') + 1", which will even drop the time dimension. See ADDEACH to add to each element of a node.

Standard Operations

Most Used Operations

The above standard operations and:

All Operations / Functions

A function is used in value driver models to calculate with multi-dimensional data cubes.

Combined Operations

Compare Values

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.