Brian Dunning's FileMaker Custom Functions

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

Bruce Robertson   Bruce Robertson

Share on Facebook Share on Twitter

  Sample input:
RepMatchSum ( "Qty"; "ProductID"; "X123"; 20 ; 6)
  Sample output:
23

  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.

UPDATED 7/31/08
New feature to count matches if datafield and matchfield are the same.

 

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.

Under construction. Email me your wish list for improvements.