Returns the largest value in the given table's column which complies with the specified condition.
DMax([Table or Table Name],[Column Index],[Condition])
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.
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. |