MIN macro
The MIN macro is available in HCL® Campaign and HCL Interact.
Syntax
MIN(data [, keyword])
Parameters
data
The
numerical values to compute the minimum of. This can be a constant
value, a column, a cell range, or an expression evaluating to any
of the above. For the format definition of data
,
see the "Macro Function Parameters" section in the chapter
in this guide for your HCL
product.
keyword
This optional keyword determines how the computation is performed over the input data range. Select one of the following:
ALL
- Performs the computation on all cells in data
(default)
COL
- Performs the computation
separately for each column of data
ROW
- Performs the computation separately for each row of data
See DATE for more details on using keywords.
{ALL | COL | ROW}
. These
keywords do not apply in HCL
Campaign
because the input data is always a single column
or field. The macro will always behave as if the COL
keyword were specified. Therefore, you do not need to specify these
keywords when using HCL
Campaign .Description
MIN
calculates
the minimum of all the cells in the specified data range. It returns
a single column containing the minimum value.
Examples
TEMP = MIN(V1) Creates
a new column named |
TEMP = MIN(V1:V3) Creates
a new column named |
TEMP = MIN(V1[10:20])
Creates a new column named |
TEMP = MIN(V1[1:5]:V4)
Creates a new column named |
TEMP = MIN(V1:V3, COL)
Creates three new columns named |
TEMP = MIN(V1[1:5]:V3, COL)
Creates three new columns named |
TEMP = MIN(V1:V3, ROW)
Creates a new columns named |
TEMP = MIN(V1[10:20]:V3, ROW)
Creates a new column named |
Related Functions
Function | Description |
---|---|
MAX |
Computes the maximum of a range of cells |
MAX_TO_INDEX |
Returns the column index of the maximum value for each row of the specified column |