MIN clause
Synopsis
MIN field [GRAND.TOTAL "label"]
Description
The MIN clause returns the minimum numeric value for a field. If a WITH clause (or some other conditional clause) is specified, MIN returns the smallest value of the values of that field that pass the condition test.
The following example lists all of the values of the AMOUNT field, then returns the smallest of these values:
LIST SALES AMOUNT MIN AMOUNT
The following example lists all of the values of the @ID field that pass the condition test, then returns the smallest of these values:
LIST SALES MIN @ID WITH @ID > 24990
It lists a result set such as the following:
SALES..... SALES..... 24991 24991 24992 24992 24993 24993 24994 24994 24995 24995 24996 24996 24997 24997 24998 24998 24999 24999 25000 25000 *** 24991 10 Items listed.
The MIN value is listed after the detail listing, using the same format as a TOTAL value.
You can use the DET-SUPP keyword, or the (D letter code, to suppress listing individual values, as follows:
LIST SALES MIN @ID WITH @ID > 24990 DET-SUPP
Which returns:
SALES..... SALES..... *** 24991 10 Items listed.
The following example lists the total, maximum, and minimum values:
LIST SALES TOTAL @ID MAX @ID MIN @ID WITH @ID > 24990
It lists a result set such as the following:
SALES..... SALES..... SALES..... SALES..... 24991 24991 24991 24991 24992 24992 24992 24992 24993 24993 24993 24993 24994 24994 24994 24994 24995 24995 24995 24995 24996 24996 24996 24996 24997 24997 24997 24997 24998 24998 24998 24998 24999 24999 24999 24999 25000 25000 25000 25000 *** 249955 25000 24991 10 Items listed.
Note that the maximum, minimum, and total values are all listed in the same summation line in the order in which the clauses were specified. You can clarify what these values are using the GRAND.TOTAL keyword.
GRAND.TOTAL Keyword
GRAND.TOTAL and GRAND-TOTAL are synonyms.
By default, in a horizontal display the summation line is not labeled; it is indicated by the “***” placeholder. You can use the GRAND.TOTAL keyword to assign a label name to this placeholder. GRAND.TOTAL has no effect on vertical display format.
The following example uses GRAND.TOTAL to label the summation line. Note that GRAND.TOTAL does not have to directly follow the clause(s) that it affects.
LIST SALES TOTAL @ID MAX @ID MIN @ID WITH @ID > 24990 GRAND.TOTAL "Sum/Max/Min"
It returns:
SALES..... SALES..... SALES..... SALES..... 24991 24991 24991 24991 24992 24992 24992 24992 24993 24993 24993 24993 24994 24994 24994 24994 24995 24995 24995 24995 24996 24996 24996 24996 24997 24997 24997 24997 24998 24998 24998 24998 24999 24999 24999 24999 25000 25000 25000 25000 Sum/Max/Min 249955 25000 24991 10 Items listed.
