UiPath Documentation
process-mining
latest
false
Process Mining user guide

Arithmetic

Arithmetic operators available in Process Mining expressions, including addition, subtraction, and NULL handling behavior.

Addition (+)​

Description​

Calculates the sum of two values.

Syntax​

<Numeric field or Expression> + <Numeric field or Expression>

Supported values​

Supported valueResult
numeric + numericnumeric
duration + durationduration
currency + currencycurrency
percentage + percentagepercentage
timestamp + durationtimestamp

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 valuesResult
numeric - numericnumeric
duration - durationduration
currency - currencycurrency
percentage - percentagepercentage
timestamp - durationtimestamp
timestamp - timestampduration

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 valuesResult
numeric * numericnumeric
duration * numericduration
currency * numericcurrency
percentage * numericpercentage
percentage * percentagepercentage
numeric * percentagenumeric
duration * percentageduration
currency * percentagecurrency

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 valuesResult
numeric / numericnumeric
duration / durationnumeric
currency / currencynumeric
percentage / numericpercentage
duration / numericduration
currency / numericcurrency

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​

% of <Numeric field or Expression> in <Numeric field or Expression>

Supported values​

Supported valuesResult
numeric / numericpercentage
duration / durationpercentage
currency / currencypercentage

NULL handling​

If any of the inputs is NULL, the result is NULL.

Example​

% Number of events in Variants

Was this page helpful?

Connect

Need help? Support(opens in new window)

Want to learn? UiPath Academy(opens in new window)

Have questions? UiPath Forum(opens in new window)

Stay updated