Brian Dunning's FileMaker Custom Functions

getMaxValue ( theList )

Returns maximum value in a list

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

Bob Patin   Bob Patin
Longterm Solutions LLC
http://www.longtermsolutions.com

Share on Facebook Share on Twitter

  Sample input:
getMaxValue ("1¶2¶3¶")
  Sample output:
3

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

Takes a list and returns the max value

 

Comments

comment   comment, VR
Jan 13, 2012
Huh?

getMaxValue ( "2¶3¶1" ) returns 2.
 
Bart Bartholomay   Bart Bartholomay, Vero Beach
Jan 13, 2012
What's wrong with:

Max ( 2 : 3 ; 1 )
 
Bob Patin   Bob Patin, Brentwood, TN
Jan 13, 2012
I was writing this to walk a portal, but you're right, I could take my list, substitute and probably make it work that way.
 

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.

Under construction. Email me your wish list for improvements.