Caché MultiValue Basic Reference
MINIMUM
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

Returns the smallest numeric value from the elements of a dynamic array.
Synopsis
MINIMUM(dynarray)
Arguments
dynarray An expression that resolves to a dynamic array of numeric values.
Description
The MINIMUM function compares the values of all of the elements in a dynamic array and returns the smallest numeric value. The MINIMUM function compares all dynamic array values, regardless of the dynamic array levels of the elements. If an element value missing or has a null string or non-numeric value, MINIMUM parses its value as 0 (zero).
Examples
The following example uses the MINIMUM function to return the smallest numeric value in a dynamic array:
a=10:@FM:9:@VM:8:@SM:7
PRINT MINIMUM(a);    ! returns 7
See Also