FileMaker Pro Custom Functions

Search  |  List  |  Show Random  |  Upload  |  Add This to Your Site

TotalList ( valueList )

Stefano Lesandrini, ITC Information Technologies Consultants
http://web.ticino.com/itc-didag

Get the total of all number values of a given list

Description:

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

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

digg this page | del.icio.us this page

Download the Custom Function Dashboard Widget for OS X Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions: 1. CustomList_BottomUp ( Start ; End ; Function )   (Mon, Jul 21, 5:44am) 2. ColumnsAcross ( listOfValues ; numberOfColumns ; columnDelimiter )   (Tue, Jul 15, 8:01am) 3. _cf_Country_Letter_Code ( _Country )   (Mon, Jul 14, 8:02pm)

Custom Function Authors:
Link to all of your own custom functions on this site with the following URL:
http://www.briandunning.com/filemaker-custom-functions/results.php?author=Your Name Here