Progress
Report Builder
User’s Guide


MINIMUM

Compares two or more values and returns the smallest.

SYNTAX

MINIMUM ( expression , expression [ , expression ] ... ) 

expression

A constant, field name, or expression. All the values must have the same data type.

When comparing character values, if at least one of the character fields is defined as case sensitive, then MINIMUM treats all of the values as case sensitive for the sake of the comparison. If none of the values is case sensitive, MINIMUM treats lowercase letters as uppercase letters.

EXAMPLE

To prevent discounts of greater than 50%, create a calculated field containing this expression:

MINIMUM(Discount-Rate,50) 

Discount-Rate is a calculated field with the following expression:

.01 * Qty 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095