IBM® Macros Reference
This section provides reference information for the available spreadsheet macro functions in the IBM® Marketing Platform suite.
The available macros are listed on the following pages, in alphabetical order. Each macro is provided with its syntax, possible parameters, and some examples.
*
Do not use function names or keywords from the IBM® Macro Language for column headings on user tables in IBM® Campaign, whether mapping from a database or a flat file. These reserved words can cause errors if used in column headings on mapped tables.
ABS
ACOS
ACOT
ADD_MONTHS
ALIGN
AND
ASIN
ATAN
AVG
AVG_DEV
BETWEEN
BIT_AND
BIT_NOT
BIT_OR
BIT_XOR
BUFFER
CEILING
COLUMN
CONSTANT
COS
COSH
COT
COUNT
COUNT_DIFF
COV
CURRENT_DATE
CURRENT_DAY
CURRENT_JULIAN
CURRENT_MONTH
CURRENT_TIME
CURRENT_WEEKDAY
CURRENT_YEAR
CV_FOLDS
DATALINK
DATE
DATE_FORMAT
DATE_JULIAN
DATE_STRING
DAY_BETWEEN
DAY_FROMNOW
DAY_INTERVAL
DAYOF
DDELINK
DECIMATE
DELAY
DERIVATIVE
DISTANCE
DISTINCT
DIV
EQ
EXP
EXTERNALCALLOUT
EXTRACT
FACTORIAL
FLOOR
FORMAT
FRACTION
GAUSS
GAUSS_AREA
GE
GRID
GROUPBY
GROUPBY_WHERE
GT
HISTOGRAM
IF
IN
INIT
INT
INTEGRAL
INVERSE
IS
ISERROR
ISEVEN
ISMEMBER
ISODD
KURTOSIS
LAG
LE
LIKE
LN or LOG
LOG2
LOG10
LOWER
LT
LTRIM
MAX
MAXINDEX
MEAN
MERGE
MIN
MINUS
MOD
MONTHOF
MULT
NE
NORM_MINMAX
NORM_SIGMOID
NORM_ZSCORE
NOT
NPV
NUMBER
OFFSET
OR
PCA
PCA_FEATURES
POSITION
PLUS
POW
RANDOM
RANDOM_GAUSS
RANK
REPEAT
ROTATE_LEFT
ROTATE_RIGHT
ROUND
ROWNUM
RTRIM
SAMPLE_RANDOM
SELECT
SIGN
SIN
SINH
SKEW
SLIDE_WINDOW
SORT
SQRT
STAT
STDV or STDEV
STRING_CONCAT
STRING_HEAD
STRING_LENGTH
STRING_PROPER
STRING_SEG
STRING_TAIL
SUBSAMPLE
SUBSTITUTE
SUBSTR or SUBSTRING
SUM
TAN
TANH
TO
TOTAL
TRANSPOSE
TRUNCATE
UPPER
VARIANCE
WEEKDAY
WEEKDAYOF
XOR
XTAB
YEAROF