TotalList ( valueList )
Get the total of all number values of a given list
Average rating: 4.4 (30 votes) Log in to vote
SL - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
All the credits to Mr Geoff Wells (http://www.dataisland.com) who had written the original one.
Because the use of LeftWords() and RightWords() Geoff's CF was not able to properly add any numbers less than 1 to the total.
For example: TotalList (".11¶.22¶1") returned as result 34 instead of 1.33
Now TotalList (".11¶.22¶1") returns 1.33
Why the old CF was wrong?
LeftWords() and Rightwords() use not-alphanumeric chars as word's separators so:
LeftWords(".11¶.22¶1" ; 1) returns "11".
LeftValues(".11¶.22¶1" ; 1) instead returns .11
|Rob Westergaard, Davis, CA
Feb 8, 2010
|Is there a situation where the following non-recursive function wouldn't accomplish the same task?
Evaluate ( "Sum ( GetAsNumber ( \"" & Substitute ( valueList ; "¶" ; "\" ) ; GetAsNumber ( \"" ) & "\" ) )" )
Mar 18, 2011
|Does not handle negative numbers|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.