AVERAGE function averages the non-blank values in a subform's field or in two or more fields.
AVERAGE(VALUE1, VALUE2, VALUE3, ...) AVERAGE(SUBFORM_FIELD.FIELD_NAME)
When used with subform fields, the argument to
AVERAGE() must include a reference to the form's subform field and then the field within the subform, using the dot notation.
AVERAGE function only accepts numeric or boolean arguments.
For the purpose of averaging logical values,
TRUE values are treated as 1.0 and
FALSE values are treated as 0.0.
If you have a household survey form with a "Members" subform, you can use the
AVERAGE function to find the average age of the members.
Note that blank values are ignored. If you the
AGE field is optional, and there are blank values, then the blank values are excluded from the average:
AVERAGE(MEMBERS.AGE) would be equal to (25+30)/2, or 25.