Max function and List of Values

dataservices job design
1

The documentation says that max “Returns the maximum value from a list” and is in the form max(value_list).
I am looking for something like Excel =max(3,5,4) returns 5 (really max(colA, colB, colC of course).
It gave me the nice two blue triangles for validation inside the query but then when I validated the dataflow, it said “BODI-1112351…Calling with <3> parameters, but <1> are expected”.
Well yes it is in the Aggregate group, and the syntax helper asks for a column name, but is there a secret to getting it to work with a list? Are there two different functions, one that wants a column name and one that will take a list of values, and if so, how do I get them? Or am I stuck with a list of ifthenelse’s (especially if my list is long)?
Thanks.

pbackstrom (BOB member since 2007-11-14)

2

max() is an aggregation function for one column multiple rows like in


    3
max(5) = 5
    4

What you are looking for is the greatest function:

greatest(3,5,4,…) = 5

Werner Daehn :de: (BOB member since 2004-12-17)

3

Just what I needed, thanks.

pbackstrom (BOB member since 2007-11-14)