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])
Where:
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.
Rule | Meaning |
|---|---|
| DMax(DwLookupDataTable,1,">10") | This will look in the table DataTable, in column 1 and return the largest value that is greater than 10. |