ListOperation ( list ; operator )
Apply a mathematical operation to every value in a (text) list.
Average rating: 4.2 (29 votes) Log in to vote
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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.