Returns the largest value in the given table's column which complies with the specified condition.
DMax([Table or Table Name],[Column Index],[Condition], [Ignore Whitespace])
Table or Table Name is the table to search in.
Column Index is a number representing the index of the column in the table.
Condition is the condition to test each cell in the column with.
Ignore Whitespace (optional) is True to ignore leading/trailing whitespace characters in text strings in the condition, otherwise False.
|DMax(DwLookupDataTable,1,">10")||This will look in the table DataTable, in column 1 and return the largest value that is greater than 10.|