
1. Re: Average based on one group of values
philmodjunk Mar 22, 2014 11:41 AM (in response to SeanLang)There are three syntax options to an aggregate function:
Average ( Field1 ; Field2 ; field3 ) will average the values of these three fields that are all defined in the same record. That's the forum you are seeing described as: Average ( field { ; field })
If you just use Average ( Field ), that's the same as asking "what is the average of 5? and the average of 5 is 5.
But you also can use:
Average ( RepeatingField ) where averages computes the average (mean) of all the values stored in repetitions of the repeating field
And the option you should use is:
Average ( Buildings::CompletionPct ) where you compute the average from all related records. The key is to define this as a calculation field in Projects, not Buildings.
Note: An "average of" summary field can also be used to compute the same average.

2. Re: Average based on one group of values
SeanLang Mar 22, 2014 4:40 PM (in response to SeanLang)Thanks, Once I figured out what table to base it on, it seemed to work perfectly.
...Getting there! This program sure is fun to learn! It hardly seems like work.