FACTORIAL macro

The FACTORIAL macro is available only in Unica Campaign.

Syntax

FACTORIAL(data)

Parameters

data

The integer values to compute the factorial for. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above, but must be greater than or equal to zero. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your product.

Description

FACTORIAL calculates the factorial of the values in the specified data range. All inputs must be integers greater than or equal to zero. The factorial of an integer less than or equal to one is one. For integers X ≥ 2, the factorial x! = x (x-1)(x-2)…(x - (x-1)). FACTORIAL returns one new column for each input column, each containing the factorial of numbers in the corresponding input column.

Note: Any value greater than 34 will produce ??? (floating-point overflow error).

Examples

TEMP = FACTORIAL(3)

Creates a new column named TEMP containing the value 6.

TEMP = FACTORIAL(-2)

Generates an error 333, indicating that the argument must be greater than or equal to 0.

TEMP = FACTORIAL(V1)

Creates a new column named TEMP, where each value is the factorial of the contents of column V1.

TEMP = FACTORIAL(V1:V3)

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the factorials of the contents of column V1, the values of the VX column are the factorials of the contents of column V2, and the values of the VY column are the factorials of the contents of column V3.

TEMP = FACTORIAL(V1[10:20])

Creates a new column named TEMP, where the first 11 cells contain the factorials of the values in rows 10-20 of column V1. The other cells in TEMP are empty.

TEMP = FACTORIAL(V1[50:99]:V2)

Creates two new columns named TEMP and VX, each with values in rows 1-50 (the other cells are empty). The values in column TEMP are the factorials of the rows of column V1, and the values in column VX are the factorials of the values in column V2.