MaxNumValue ( valuelist ; value )

Returns max numeric value from a list

Average rating: 4.6 (33 votes) Log in to vote

Danny De Vylder
SHpartners - myFMbutler
http://myfmbutler.com

Sample input:

MaxNumValue ( "1¶2¶9¶25, "" )

Sample output:

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

/* --------------------------------------------------------------------------------
Returns the largest numeric value in the valuelist

Syntax: MaxValue ( valuelist ; currentValue )
In: valuelist - the return delimited valuelist to search
     value - the value currently compared

Return type: Numeric 

MaxValue ( "1¶2¶9¶25" ; "" )  --> "25"

Always start the function off with parameter 'value' = ""

Danny De Vylder - based on MaxValue by Theo Ros
-------------------------------------------------------------------------------- */

If ( ValueCount ( valuelist ) ; 

Let ( 
[ 
next = GetAsNumber( Substitute ( LeftValues ( valuelist ; 1 ) ; "¶" ; "" ) );
current = GetAsNumber ( Substitute ( value ; "¶" ; "" ) ) ;
rest = MiddleValues ( valuelist ; 2 ; 9999999999 ) ;
high = GetAsNumber ( Case ( IsEmpty ( current ) ; next ; next > current ; next ; current ) )
] ; 

If ( ValueCount ( rest ) ; MaxNumValue ( rest ; high ) ; high )
  )
)

Returns max numeric value from a list of numerical values

Comments

		Emma, Leeds, UK Jan 27, 2012
The first custom function I've used, does exactly what I want and saved me lots of bother! Thanks

		Daniel Jul 17, 2017
This recursive function is unnecessary, you can utilize the native Max() function. To use that function with a list, see http://www.briandunning.com/cf/757

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

MaxNumValue ( valuelist ; value )

Comments

Support this website.

Support this website.