LOG() returns the logarithm (base 10) of a numeric expression or field value with a specified number of decimal places. LOG() is the inverse of the EXP() function.
Use LOG() for financial applications requiring complex mathematical calculations.
LOGARITHM(N,#)
| • | # is a numeric constant representing decimal places that cannot change from record to record. |
LOG() returns the common logarithm (base 10) of the numeric expression or field value N with # decimal places. 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 inverse of a logarithm is its exponent.
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)
Note: You determine the Nth root by dividing the log of the value by N and taking the exponential value of the result.