LOG function
This topic describes the formula syntax and usage of the LOG function in the Data Quality Execute Formula transform.
Description
Returns the logarithm of a number to a specified base (default is 10).
Syntax
LOG(number,[base])The LOG function syntax has the following arguments:
NumberRequired. The positive real number for which you want the logarithm.BaseOptional. The base of the logarithm. If base is omitted, it is assumed to be 10.
Example
| Value | Formula | Description | Result |
|---|---|---|---|
10 |
LOG([Value]) |
Logarithm of 10. The base is equal to 10 when it is omitted. | 1 |
8 |
LOG([Value],2) |
Logarithm of 8 with base 2. The result is the power to which the base must be raised to equal 8. | 3 |
86 |
LOG([Value],2.7182818) |
Logarithm of 86 with base e (approximately 2.718). The result is the power to which the base must be raised to equal 86. | 4.4543473 |