Help Centre › Functions & Formulas
This article describes the RPA Data functionality to sum data.
For a full list of available functions, please read DATA functions.
Description
The DATA Sum data function allows you to sum data.
Setting it up
To use the DATA Sum data function, follow these instructions:
{{popups:rpas/add:action=data-sum}}
Once on a process map:
- Navigate to the process where you would like to add the DATA Sum data function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the DATA Sum data option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Variable | Yes | Text | - | Variable containing the data |
| Column | Yes | Text | - | The column to sum |
| Field / Operator / Value filters | Yes | Table | - | Optional filter criteria |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Number | The sum of values in the specified column |
Errors
| Error | Description |
|---|---|
| Variable empty | The variable contains no data |
| Column not found | The specified column does not exist |
Tips
- Sums numeric values in a specific column
- Use filters to sum only matching rows