Calculate the average value of the specified fields in the table. You can reuse the result of the calculation in other Actions.
Set Filed to Calculate, Target Field (Optional), and If no rows in the table.
Select the field in the table to calculate the average. This parameter accepts the following field types:
The “Calculation” field type must be in numeric format. The “Calculated” field in Date, Time, and Date & time formats is not supported.
Use this parameter to set the results to another field. You can leave this parameter empty to use the calculation result in another action without setting it to any field.
This parameter accepts the following field types: Fields in tables cannot be selected.
Select the action when there are no rows in the table. Based on the selection made, the value and result value for the action entered in the “Target Field” when no rows meet the conditions will be as follows:
| Parameter Value | Value to be set in the “Target Field” | Action Result |
|---|---|---|
| Set nothing | Do not change the value of the field | undefined |
| Set blank | Clear the value | undefined |
| Set zero | 0 | 0 |
| Set NaN | NaN | NaN |
The calculation results will not be rounded. To round the results, use with another action, such as “Round Off Field Value.”
When calculating the average, the number of table rows serves as the denominator, and this row count includes rows where the value of the “Field to Calculate” is empty.