ConsecCount ( ItemList ; StartingItem )
Counts how many consecutive years (or other numbers) are in a field from a particular starting point.
Average rating: 4.5 (24 votes) Log in to vote
FM Professional Solutions
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Uses a recursive function to count how many consecutive years (or other numbers) are in a field from a particular starting point going backward.
ItemList would be either a text field that contains all the values, or else it might be derived from a set of related records using the valuelistitems() function.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.