Help Centre › Building Processes
This article describes the RPA Excel functionality to execute a function (average, count, max, min, sum).
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Aggregate column (average, count, max, min, sum) function allows you to execute a function (average, count, max, min, sum).
Setting it up
To use the EXCEL Aggregate column (average, count, max, min, sum) function, follow these instructions:
{{popups:rpas/add:action=excel-aggregate}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Aggregate column (average, count, max, min, sum) 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 EXCEL Aggregate column (average, count, max, min, sum) option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Name of the target sheet. |
| Column / Function pairs | Yes | Key-Value | – | Column names and the function to apply: Sum, Average, Count, Max, or Min. |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| Sheet not found | The specified sheet does not exist. |
| Column not found | The specified column name does not exist. |
Tips
- Results are written to the first empty row below the data in each column.