Receive an array and return the summation average value in the array.
If you specify something that does not represent a number, NaN (indicating that it is not a number) is returned.
If an element in the array is empty, its value is not added, but the empty element is also counted as the denominator of the division.
In the following example, suppose the #1 action was to retrieve all records, such as Retrieve All Records. Get the average value in the number column in this #1 action.
= avg ($1. Number)
In the following example, "" is not an additive target but is counted in the denominator on average, so the avg returns 12 /5 = 2.4.
= avg([1, 2, "", 4, 5])