Brian Dunning's FileMaker Custom Functions

ListOperation ( list ; operator )

Apply a mathematical operation to every value in a (text) list.

  Average rating: 4.2 (29 votes) Log in to vote

Kieren MacMillan   Kieren MacMillan
kierencom
http://www.kierencom.ca

Share on Facebook Share on Twitter

  Sample input:
ListOperation ( "1 2 3 4" ; "+" )
  Sample output:
10

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

Substitutes the supplied mathematical operator for spaces and hard returns -- modifiable for other substitutions, of course -- and evaluates the resulting formula. Great for adding or multiplying a list of numbers.

Note: does not error check for leading/trailing spaces or returns -- use my "TrimCharacter" function to handle such cases.

 

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.