Arithmetic Operators (MDX)
Arithmetic operators perform basic math operations on their operands. AtScale supports arithmetic operators in Calculated Measure formulas. Notice the NULL handling behavior in MDX is different than SQL.
| Operator | Description | Examples |
|---|---|---|
| + | Addition String Concatenation | 1 + 2 = 3 1 + NULL = 1 'Name' + 1 = Name1 'Hello' + 'World' = 'Hello World' [Measures].[sale_amount] + [Measures].[tax] see also SQLSUM |
| - | Subtraction | 2 - 1 = 1 2 - NULL = 2 [Measures].[sale_amount] - [Measures].[discount] |
| * | Multiplication | 2 * 2 = 4 2 * NULL = NULL [Measures].[sale_amount] * .085 |
| / | Division | 4 / 2 = 2 4 / 0 = undefined 4 / NULL = NULL NULL / 2 = NULL [Measures].[bytes] / 1048576 |
| ^ | Power | 2 ^ 3 = 8 area = 3.14 * r ^ 2 [Measures].[bytes] ^ 2 |
can return NULL or an error depending on the SQL engine