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
|
Howard Schlossberg - Show more from this author
FM Professional Solutions http://fmprosolutions.com |
Sample input:
ConsecCount ( "2004¶2003¶2002¶1999¶1998" ; "2003" )
Sample output:
2
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.
Comments
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.