FACT function
This topic describes the formula syntax and usage of the FACT function in the Data Quality Execute Formula transform.
Description
Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...*number
Syntax
FACT(number)The FACT function syntax has the following argument:
numberRequired. A nonnegative number for which to calculate the factorial. If number is not an integer, it is truncated.
Example
Data: 5, 2.8, 0, -1, 1 in Number field.
| Formula | Description | Result |
|---|---|---|
FACT([Number1]) |
Factorial of 5, or 1*2*3*4*5 | 120 |
FACT([Number2]) |
Factorial of 2.8 (truncates to 2) | 2 |
FACT([Number3]) |
Factorial of 0 is always 1 | 1 |
FACT([Number4]) |
Factorial of a negative number returns an error. | |
FACT([Number5]) |
Factorial of 1 | 1 |