Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

MaxValue ( lst ; value )

Returns the largest value in the list

  Average rating: 4.3 (30 votes) Log in to vote

Theo Ros - Show more from this author

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

/* -------------------------------------------------------------------------------- Returns the largest value in the lst Syntax: MaxValue ( lst ; value ) In: lst - the return delimited lst to search value - the value currently compared Return type: Text MaxValue ( "apple¶grape¶banana" ; "" ) --> "grape" Always start the function off with parameter 'value' = "" Theo Ros * updated augustus 9, 2010: changed parameter name "list" to "lst" thanks to Dwayne Wright -------------------------------------------------------------------------------- */ If ( ValueCount ( lst ) ; Let ( [ next = Substitute ( LeftValues ( lst ; 1 ) ; "¶" ; "" ) ; current = Substitute ( value ; "¶" ; "" ) ; rest = MiddleValues ( lst ; 2 ; 9999999999 ) ; high = Case ( IsEmpty ( current ) ; next ; next > current ; next ; current ) ] ; If ( ValueCount ( rest ) ; MaxValue ( rest ; high ) ; high ) ) ) Click to copy

Returns the largest value in the list

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

Return type: Text

MaxValue ( "apple¶grape¶banana" ; "" ) --> "grape"

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

 

Comments

		Michael MEAD, FRESHWATER Apr 19, 2017
When I Cut & paste I get an error message in the final line: "An operator (e.g. +,-,*,...) is expected here. If ( ValueCount ( rest ) ; MaxValue { the cursor is here}( rest ; high ) ; high ) )

		Theo, Hilversum May 1, 2017
Hi Michael, that's because you did not cut all of it and you have missed the final closing bracket. Please use the Select All button and then copy/paste.

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: