- Before you begin
- Managing access
- Getting started
- Integrations
- Working with process apps
- Working with dashboards and charts
- Working with process graphs
- Working with Discover process models and Import BPMN models
- Showing or hiding the menu
- Context information
- Export
- Filters
- Sending automation ideas to UiPath® Automation Hub
- Tags
- Due dates
- Compare
- Conformance checking
- Process simulation
- Root cause analysis (Preview)
- Simulating automation potential
- Starting a Task Mining project from Process Mining
- Triggering an automation from a process app
- Viewing Process data
- Process Insights (preview)
- Creating apps
- Loading data
- Transforming data
- Autopilot™ for SQL (preview)
- Structure of transformations
- Tips for writing SQL
- Exporting and importing transformations
- Viewing the data run logs
- Merging event logs
- Configuring Tags
- Configuring Due dates
- Configuring fields for Automation potential
- Activity Configuration: Defining activity order
- Making the transformations available in dashboards
- Data models
- Adding and editing processes
- Customizing dashboards
- Publishing process apps
- App templates
- Notifications
- Additional resources
Process Mining user guide
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
% of <Numeric field or Expression> in <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 in Variants