LOG( ) function

Returns the logarithm (base 10) of a numeric expression or field value with a specified number of decimal places.

Syntax

LOG(number, decimals)

Parameters

number

Numeric. The value to find the logarithm for.

decimals

Numeric constant. The number of decimal places for the return value.

Output

Numeric.

Remarks

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.

Examples

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)
Note

You determine the nth root by dividing the log of the value by n and taking the exponential value of the result.

Related reference
EXP( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback