Type
Relational Statistical Operator

Purpose
The lowest of operator finds the smallest value in the specified field in all matching records in a related table. The result can appear as a list item in the detail area of a report or as a statistic at the end of each group or at the end of the report.

Syntax
lowest of TABLENAME|RELATIONSHIP
[named "UNIQUE RELATIONSHIP NAME" ] ]
[with ( selection criteria) ] FIELDNAME ;|.

Returns
A value of the same type as the specified field. If a Text field is specified, DataEase returns the lowest ASCII value. If a Choice field is specified, DataEase returns the value in the lowest numbered choice (not necessarily the lowest ASCII value).

Usage
There's an important difference between the statistical operator min and the relational statistical operator lowest of. min returns the lowest value in the specified field among the records being processed. lowest of returns the lowest value in the specified field among the records related to the records being processed.
Example
for MEMBERS ;
list records
LAST NAME in order ;
lowest of RESERVATIONS TOTAL DUE .
end

This script tells DataEase: (1) Process all the MEMBERS records and list each member's LAST NAME in alphabetical order, (2) for each MEMBERS record selected, find the related records in the RESERVATIONS table (those that have the same MEMBERID), and (3) list the lowest TOTAL DUE value for each of the matching RESERVATIONS records.
The output from this script arranged in alphabetical order by LAST NAME, might look as follows:

Last Name
Lowest of Reservations Total Due
Adams
$2740.00
Albert
$4100.00
Anders
$3690.00
Anderson...
$1720.00...

If you also want to include the smallest TOTAL DUE among this group of reservations, change the fourth line of the query to read:

lowest of RESERVATIONS TOTAL DUE : item min .