DriveWorks Pro 17: DMin [send feedback...]

DMin

Returns the smallest value in the given table's column which complies with the specified condition.

Syntax

DMin([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.

Examples

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.

Table of Contents