DriveWorks Pro 15: DMax [send feedback...]

DMax

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

Syntax

DMAX([Table or Table Name],[Column Index],[Condition])

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
DMAX(DwLookupDataTable,1,">10")This will look in the table DataTable, in column 1 and return the largest value that is less than 10.

Table of Contents