EXP function
This topic describes the formula syntax and usage of the EXP function in the Data Quality Execute Formula transform.
Description
Returns the mathematical constant e raised to the power of a given number. The constant e is approximately equal to 2.71828182845904, the base of the natural logarithms. It is also the limit of (1 + 1/n)n as n approaches infinity.
Syntax
EXP(number)The EXP function syntax has the following argument:
number Required. The exponent applied to the base e.
Notes
- To calculate powers of other bases, use the exponentiation operator (
^). - EXP is the inverse of LN, the natural logarithm of
number.
Example
| Data | Formula | Description | Result |
|---|---|---|---|
| 1 | EXP(Data) |
Approximate value of e. | 2.71828183 |
| 2 | EXP(Data) |
Base of the natural logarithm e raised to the power of two. | 7.3890561 |