max function only allows two arguments?

[pglavin]

I need a function that will return the highest value from a set of numerical
variables. The max function only works with two numbers.

e.g. <cfif #crystallization_avg# IS max(#crystallization_avg#,
#specification#, #implementation#)>

Any ideas?

Thanks,

Paul

[jdeline]

Put them in a list or array and sort them.

[dempster]

If you have a list (or set) of numerical values named mylist, you can get the maximum value like this:

ListGetAt(ListSort(mylist, "Numeric", "desc"),1)

-Paul

[mxstu]

pglavin,

If you're using a list, take a look at the [url]http://cflib.org/udf.cfm?ID=806[/url]
function at cflib.org. It's very easy to use.

The basic concept is that you take a list of values, convert the list to an
array and use ArrayMax() to get the maximum value.

<cfset listOfValues = "12,14.3,122.6,8,19.26,4">
<cfset maxValue = ArrayMax(ListToArray(listOfValues))>
<cfoutput>#MaxValue#</cfoutput>

As an alternative you could easily create your own UDF that accepts a variable
number of parameters (instead of a single list of values).

[pglavin]

Many thanks,

Paul