SumList ( theList )

Sums a list. Normally this would be very quick and easy, but sometimes having null values can mess up what would otherwise be a very simple process.

Be the first to rate this function Log in to vote

Paul - Show more from this author
Peak 14 LLC
http://www.peak14.solutions

Sample input:

SumList ( ¶ 1 ¶ ¶ 5 ¶ 9 )

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
 *  CUSTOM FUNCTION
 *    SumList ( theList )
 *
 *  DESCRIPTION
 *    Sums all values in a list together
 *
 *  PARAMS
 *    theList: the list the contains the values you want to sum
 *
 *  RETURNS
 *    Number
 *
 *  DEPENDENCIES
 *    --NONE--
 *
 *  CHANGELOG
 *    2020-06-26: Paul McCudden (paul@peak14.solutions): Created
 *
 *  CREDITS
 *    Credit goes to Debi Fuchs of Aptworks Consulting, debi@aptworks.com for the strategy of getting rid of null list values
*/

Let(
    [
        ~s = Get(UUID); // very unlikely string
        ~newList = If(
            // Check if unlikely string rears its head
            Position( theList; ~s; 0; 1 );

            // If so, simulate an out-of-range error.
            Evaluate( "Factorial( -1 )" ); 

            // Otherwise, proceed to get rid of nulls, than add a + between the remaining values
            Substitute( ~s & theList & ~s;
                [ "¶¶"; ¶ & ~s & ¶ ];
                [ "¶¶"; ¶ & ~s & ¶ ];
                [ ~s & ¶; "" ];
                [ ¶ & ~s; "" ];
                [ ~s; "" ];
                [ ¶ ; "+" ]
            )
        )
    ];

    If ( IsEmpty ( ~newList ) ; 0 ; Evaluate ( ~newList ) )
    
)

Sums a list. Normally this would be very quick and easy, but sometimes having null values can mess up what would otherwise be a very simple process.

Credits go to Debi Fuchs of Aptworks Consulting, debi@aptworks.com for the strategy of getting rid of null list values: https://www.briandunning.com/cf/897.

Comments

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

SumList ( theList )

Comments

Support this website.

Support this website.