RepMatchSum ( dataField ; matchField ; matchValue ; reps ; recNum )
Sum repeating field for reps where label field = matchvalue
Average rating: 4.2 (37 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Ack! Summarizing repeating fields!
For nth record, get a total for a repeating numeric data field where a label field such as productID = matchValue.
When combined with CustomList or with another custom function, you can summarize repeating fields across a found set.
New feature to count matches if datafield and matchfield are the same.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.