ListMax ( theList )

Finds the max value of a list

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:

ListMax ( 4.5¶5¶-3 )

Sample output:

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

/*
 *  CUSTOM FUNCTION
 *    ListMax ( theList )
 *
 *  DESCRIPTION
 *    Finds the max value of a list
 *
 *  PARAMS
 *    theList: the list the contains the values you want to find the max of
 *
 *  RETURNS
 *    Number
 *
 *  DEPENDENCIES
 *    --NONE--
 *
 *  CHANGELOG
 *    2021-11-04: 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(
    [
        ~unique = Get(UUID);
        ~newList = Substitute( ~unique & Filter( theList; "0123456789¶.-" ) & ~unique;
            [ "¶¶"; ¶ & ~unique & ¶ ];
            [ "¶¶"; ¶ & ~unique & ¶ ];
            [ ~unique & ¶; "" ];
            [ ¶ & ~unique; "" ];
            [ ~unique; "" ];
            [ ¶ ; ";" ]
        )
    ];

    Case ( 
        IsEmpty ( ~newList ); 0;
        PatternCount ( ~newList; ";" ) = 0; ~newList;
        Evaluate ( "Max(" & ~newList & ")" )
    )
    
)

Maxes a list of values and traps for several issues including non number values and empty values.

Credits go to Christian Jäger (https://www.briandunning.com/cf/757) for the inspiration of this CF.

Comments

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

ListMax ( theList )

Comments

Support this website.

Support this website.