Log (Expression Function)

The Log function (LOG) is used obtain the power to which the base value must be raised to produce the number provided.

The Log function has two parameters:

Allowed Inputs: field value or a number

The first parameter of the Log function is the value that should result from the base being raised to the resulting power. Either use the query builder or the type a value option to enter a number.

Allowed Inputs: field value or number

The second parameter is the number that represents the base of the exponentiation either use the use the Query Builder to choose a field that contains the value or use type a value to enter a number. If no value is provided ten will be used.

The output of the LOG function is the power to which the base value must be raised to produce the value.

For example LOG(1000) would result in 3 and LOG(19683,3) would result in 9.