Arithmetic
Addition (+)
Description
Calculates the sum of two values.
Syntax
<Numeric field or Expression> + <Numeric field or Expression>
Supported values
| Supported value | Result |
|---|---|
numeric + numeric | numeric |
duration + duration | duration |
currency + currency | currency |
percentage + percentage | percentage |
timestamp + duration | timestamp |
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
Case value + 1000
Subtraction (-)
Description
Calculates the difference of two values.
The second value is subtracted from the first value.
Syntax
<Numeric field or Expression> - <Numeric field or Expression>
Supported values
| Supported values | Result |
|---|---|
numeric - numeric | numeric |
duration - duration | duration |
currency - currency | currency |
percentage - percentage | percentage |
timestamp - duration | timestamp |
timestamp - timestamp | duration |
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
Case end - Case start
Multiplication (*)
Description
Calculates the product of two values.
Syntax
<Numeric field or Expression> * <Numeric field or Expression>
Supported values
| Supported values | Result |
|---|---|
numeric * numeric | numeric |
duration * numeric | duration |
currency * numeric | currency |
percentage * numeric | percentage |
percentage * percentage | percentage |
numeric * percentage | numeric |
duration * percentage | duration |
currency * percentage | currency |
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
Number of events * 365
Division (/)
Description
Calculates the quotient of two values.
The first value is divided by the second value.
Syntax
<Numeric field or Expression> / <Numeric field or Expression>
Supported values
| Supported values | Result |
|---|---|
numeric / numeric | numeric |
duration / duration | numeric |
currency / currency | numeric |
percentage / numeric | percentage |
duration / numeric | duration |
currency / numeric | currency |
NULL handling
X / 0 will return NULL.
NULL / X will return NULL.
X / NULL will return NULL.
Example
Throughput time / Number of events
Percentage (%)
Description
Calculates the percentage of two values.
The first value is divided by the second value and the result is multiplied by 100.
Syntax
<Numeric field or Expression> % <Numeric field or Expression>
Supported values
| Supported values | Result |
|---|---|
numeric / numeric | percentage |
duration / duration | percentage |
currency / currency | percentage |
NULL handling
If any of the inputs is NULL, the result is NULL.
Example
Number of events % Variants