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
All Operations / Functions
A function is used in value driver models to calculate with multi-dimensional data cubes.
Combined Operations
Compare Values
Contact
You may contact the Valsight Customer Support via:
+49 30 46799042
Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .
*Except Public holidays in Berlin, Germany.