SUMLIST ( list )
sums the numbers in a list
Average rating: 3.9 (38 votes) Log in to vote
Martin Spanjaard - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Adds the numbers in a list. We use it on our invoices, where the user is free to put the amounts in a text field.
It recursively takes the first number off the list and adds it to the rest of the list, till the list is empty.
Formatting is done recursively by two other custom functions.
Feb 8, 2010
|Bart Bartholomay, Vero Beach, FL
Feb 9, 2010
|Martin Sorich, San Jose, CA
May 14, 2010
Clever, but in FMP 10, 11 extra "+" is appended to end of string which does not evaluate properly. I suggest:
Evaluate( Left( Substitute (list;¶;"+") ; Length ( list ) -1 ) )
List is delimited by ¶ and Sum function does not work.
May 25, 2011
|@Martin - There's nothing inherently wrong with unin's function, it just assumes a proper list. It's the LeftValues and RightValues functions that are appending the carriage return.
@unin - That is so cool!
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.