Could you explain the use case? There are several ways to get the max value in a list of values, but do you also need its associated data? Are these values already in a table or collection? Is it just a list of numbers that are not associated with anything else?
Also, are you looking for the most efficient way to do this or just a way that works?
I'll give two quick options for now.
Option #1: Assuming that you do not care whether that highest number or max value is in the list more than once... Bring the numbers into a collection, where each number is on its own line. Then use the action 'Sort Collection' in the VBO 'Utility - Collection Manipulation'. Put the field name into the 'Sort Field' input. And put 'False' in the input 'Ascending Order' so that the highest number will be in the first row. The first row should be selected in the output collection. So, you should be able to use a calculation stage to get the value from the first row like '[Sorted Collection.FieldName]' to get the value. This of course ignores whether row 2, etc. also have the same value. But this is assuming you just want to know that value.
Option #2: The other way to do it that may or may not be more efficient is to (again put the numbers into rows of a collection first) loop through the collection and store the value into a data item each time you find that it is higher. You'd have a decision stage that compares the current number to the last highest number. If it is higher, then you replace the last highest number with the current number and then loop again.
------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
