Home Search

DriveWorks Pro 22
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], [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.

Examples

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.