|
Many macro functions take the keyword parameters {ALL | COL | ROW}. These keywords do not apply in IBM® 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 IBM® Campaign .
|
|
|
SUM is the same as the TOTAL macro function.
|
|
Creates a new column named TEMP containing the value three.
|
|
Creates a new column named TEMP containing the value nine.
|
|
Creates a new column named TEMP containing a single value which is the sum of the contents of column V1.
|
|
Creates a new column named TEMP containing a single value which is the sum of the contents of columns V1, V2, and V3.
|
|
Creates a new column named TEMP containing a single value which is the sum of the cells in rows 10-20 of columns V1 through V4.
|
|
Creates three new columns named TEMP, VX, and VY. The single value in the TEMP column is the sum of the contents of column V1, the single value in the VX column is the sum of the contents of column V2, and the single value in the VY column is the sum of the contents of column V3.
|
|
Creates three new columns named TEMP, VX, and VY, each containing a single value. The value in column TEMP is the sum of the cells in rows 1-5 of column V1, the value in column VX is the sum of the cells in rows 1-5 of column V2, and the value in column VY is the sum of the cells in rows 1-5 of column V3.
|
|
Creates a new columns named TEMP, where each cell entry is the sum of the corresponding row across columns V1, V2, and V3.
|
|
Creates a new column named TEMP, where the cells in rows 1-5 contain the sum of the corresponding row across columns V1 through V3. The other cells in TEMP are empty.
|
|
AVG or MEAN
|
|
Copyright IBM Corporation 2015. All Rights Reserved.
|