Returns the logarithm (base 10) of a numeric expression or field value with a specified number of decimal places.
LOG(number, decimals)
Numeric. The value to find the logarithm for.
Numeric constant. The number of decimal places for the return value.
Numeric.
The logarithm of a number is the exponent (or power) of 10 needed to generate that number. Therefore, the logarithm of 1000 is 3.
The LOG( ) function is the inverse of the EXP( ) function.
Example | Return value |
---|---|
LOG(1000, 4) |
3.0000 |
LOG(72443, 2) |
4.86 |
To create a field that is the cube root of the field X to two decimal places, specify:
EXP(LOG(X, 6) / 3, 2)
You determine the nth root by dividing the log of the value by n and taking the exponential value of the result.