Log (Expression Function)

Purpose

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

Parameters

The Log function has two parameters:

Number

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.

Base

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.

Output

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

Example

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

expression function - log.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024