Formula

The formula portion of a calculation statement tells TM1® how to calculate a value for the defined area.

Numeric constants
The simplest components of a calculation formula are numeric constants. A numeric constant consists of numerals, an optional leading sign, and an optional decimal point.
Arithmetic operators
You can combine numeric constants using the following arithmetic operators.
Using conditional logic
Use the IF function to include conditional logic in calculation statements.
Using comparison operators
You can use the following comparison operators to compare values in the formula portion of a calculation statement.
Using logical operators
You can combine expressions in a calculation statement using logical operators.
Concatenating strings
You can concatenate strings using the pipe | character.
Using cube references
The formula portion of a calculation statement can contain cube references, which retrieve values from a cube.
Internal cube references
Internal cube references use the same syntax as the area definitions.
External cube references
Use the DB function to retrieve values from external cubes.

Parent topic: Components of a calculation statement