This Do calculates the average value of a field in a group of records you have imported. You can reuse the result of this Do in other Actions.
This Do uses the following parameters: “Record”, “Field to Calculate”.
Open the list of Actions and select the Action you used to retrieve the target records.
Select the field to calculate the average value. This parameter accepts the following field types:
You cannot include fields that are within a table.
The Calculated field must contain only numeric values. Date, time, and date-time formats are not supported.
If there are no records, the result will be empty. It will not be zero.
This Do does not perform rounding at the end of the calculation. Use another Do to round the calculation result, such as the Do Round Field Value
When calculating the average, the number of records serves as the denominator; however, this total includes rows with empty values in the “Field to Calculate.”
The Calculated field with the date, time, and date-time formats are not supported for “Field to Calcurlate”.