Create a calc field that calculates the length, and a summary field that totals the calc field across the found set.
Whether you need another field for the average depends on the scenario; whatever that may be, you need
sYourNewSummaryField / Get ( FoundCount )
Re: "…summary field that totals the calc field across the found set"
The Summary field could be set to Average instead of Total.
1 of 1 people found this helpful
Watch out with calculating averages in FileMaker!
You need to determine whether empty records are counted against the average or not. The default for FileMaker is not take into account empty records ...