SumXListValues ( numbers ; x ; start )
Sum X values in a list of numbers
Average rating: 4.6 (10 votes) Log in to vote
|
Kris Weyling - Show more from this author
Digital Fusion Ltd. http://teamdf.com |
Sample input:
SumXListValues (
List ( "1" ; "2" ; "3" ; "4" ; "5" ) ;
4 ;
1
)
List ( "1" ; "2" ; "3" ; "4" ; "5" ) ;
4 ;
1
)
Sample output:
10
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Take a list of numbers, and add/sum all the numbers up to a certain point in the list. Useful for accumulative totals
Comments
 |
Bruce, Redmond WA Nov 29, 2016 |
|
| Description comments appear to be left over from function Prepend List. | ||
|
Kris Weyling, Digital Fusion Ltd. Nov 29, 2016 |
|
| Thanks for that, copied the header from another function, forgot to change the title :) | ||
 |
Tim, JEAMA Dec 4, 2016 |
|
| how would the performance of this compare? let ( _evstr=substitute( middle values (numbers ; start ; x); "¶"; "+") ; evaluate( left(_evstr; length(_evstr)-1)) ) |
||
|
unix, Japan Dec 7, 2016 |
|
| Length of _evstr may be limited ( <10,000 ?) | ||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.