MinValue ( theList ; treatAsNumeric )

obtain the min value of a list WITHOUT RECURSION (thanks to Agnes Barouh and her "CustomList")

Average rating: 4.4 (32 votes) Log in to vote

Benoit Jolly
Active Développement
http://www.actived.fr

Sample input:

MinValue("65¶123¶21" ; 1 )

MinValue("65¶123¶21" ; 0 )

MinValue("zzz65¶aaa123¶ccc21" ; 1 )

Sample output:

21

123

ccc21

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

// by Benoît Jolly -   SARL Active Développement
//
// http://www.actived.fr
//
// obtain the min value of a list WITHOUT RECURSION (thanks to Agnes Barouh and her "CustomList")
// theList : a list of values separated with ¶
// treatAsNumeric : request to handle each value as the "GetAsNumber()" of the value to be computed
//
//
// examples : 
//      MinValue("65¶123¶21" ; 1 )   => 21
//      MinValue("65¶123¶21" ; 0 )   => 123    (because the text value of 123 is inferior to the text value of 21 in the alphabetical order)
//      MinValue("zzz65¶aaa123¶ccc21" ; 1 )   => ccc21   (it does not take the letters into account for the comparison)
//



Let([

$__theListToBeComputedByMinValue = theList;

$__nbLignesToBeComputedByMinValue = ValueCount( $__theListToBeComputedByMinValue );
$__minValueOfTheCustomFunction = GetValue( $__theListToBeComputedByMinValue ;1) ;


computeTheList=
If ( 
      treatAsNumeric;
      CustomList(1; $__nbLignesToBeComputedByMinValue ; "if( GetAsNumber ( GetValue ( $__theListToBeComputedByMinValue ; [n] ) ) < GetAsNumber ($__minValueOfTheCustomFunction) ; let($__minValueOfTheCustomFunction=GetValue ( $__theListToBeComputedByMinValue ; [n]);0) ; 0 )");
      CustomList(1; $__nbLignesToBeComputedByMinValue ; "if( GetValue ( $__theListToBeComputedByMinValue ; [n] ) < $__minValueOfTheCustomFunction ; let($__minValueOfTheCustomFunction=GetValue ( $__theListToBeComputedByMinValue ; [n]);0) ; 0 )")

)

];
$__minValueOfTheCustomFunction

)

// obtain the min value of a list WITHOUT RECURSION (thanks to Agnes Barouh and her "CustomList")
// theList : a list of values separated with ¶
// treatAsNumeric : request to handle each value as the "GetAsNumber()" of the value to be computed
//
//
// examples :
// MinValue("65¶123¶21" ; 1 ) => 21
// MinValue("65¶123¶21" ; 0 ) => 123 (because the text value of 123 is inferior to the text value of 21 in the alphabetical order)
// MinValue("zzz65¶aaa123¶ccc21" ; 1 ) => ccc21 (it does not take the letters into account for the comparison)
//

Comments

		Palash, SUL Nov 5, 2019
When this function put in filemaker get an error like below. "CustomList" function is found. Please advice how it use.

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

MinValue ( theList ; treatAsNumeric )

Comments

Support this website.

Support this website.