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