Brian Dunning's FileMaker Custom Functions

Aggregate ( field ; type ; size )

Aggregate one field from the newest records of a set (FMP18+ only)

  Be the first to rate this function Log in to vote

Menno van Beek   Menno van Beek - Show more from this author
Van Beek Zakelijke Software
https://www.vbzs.nl

Share on Facebook Share on Twitter

  Sample input:
Aggregate ( MyTOC::MyNumberField ; "Sum" ; 3 )

Contenst of MyTOC::MyNumberField:
10
12
99
16
11
32
45
19
  Sample output:
101

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Aggregate the designated number of tailrecords for a field with one of the standard functions for aggregation in FM. The size set is to offset the tailrecords of the found set. Thus if 100 records are found and the size is set to 20, the first 80 records will be ignored.

You can use the standard names of the FM aggregation-function like: Average, Count, List, Max, Min, StDev, StDevP, Sum,Variance and VarianceP

This can be handy when you don't want to do a find or narrow your current set of records

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 16 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: