GetFieldStat ( Function ; Field )
Do stats from values in a field or a value list
Average rating: 4.2 (32 votes) Log in to vote
Ugo DI LUCA
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Change the function to Min, Average, Sum or whatever the aggregate function needed.
You may work with a list of values with other separators than the "¶", just change this separator to match yours
Howard, Los Angeles
Dec 20, 2012
It's a small thing, but I added a case() statement to mine, to check if there's only one value (in which case any of the aggregate functions will fail).
Here's what mine looks like (sorry, I also changed the function and parameter names to better suit my needs...but you get the idea):
// AggregateValues ( Function; Values )
ValueCount(Values) <= 1; GetValue(values; 1);
Evaluate ( Function & " ( " & Substitute ( Values ; "¶";";" ) & " )" )
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.