Returns the smallest value in the given table's column which complies with the specified condition.
DMin([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 |
|---|---|
| DMin(DwLookupDataTable,1,"<10") | This will look in the table DataTable, in column 1 and return the smallest value that is less than 10. |