View Source

Computes the logarithm of the first argument with a base of the second argument.

First argument can be a Decimal or Integer literal or a reference to a column containing numeric values.
Second argument, the base, must be an Integer value or column reference.

Numeric literal example:

log(49, 7)

Output: Returns 2.

Column reference example:

log(MyValue, 5)

Output: Returns the exponent that raises 5 to yield the MyValue column.

log(result_numeric_value, base_numeric_value)

Argument	Required?	Data Type	Description
result_numeric_value	Y	string, decimal, or integer	Name of column or Decimal or Integer literal that is generated by the `LOG` function
base_numeric_value	Y	string, decimal, or integer	Name of column or Decimal or Integer literal that serves as the base for computing the `LOG` function

Name of the column or numeric literal. Value must be greater than 0.

Missing input values generate missing results.
Literal numeric values should not be quoted. Quoted values are treated as strings.
Multiple columns and wildcards are not supported.

Required?	Data Type	Example Value
Yes	String (column reference) or Integer or Decimal literal	`49`

Name of the column or Integer literal that is used for the exponential calculation.

NOTE: This base value must be a positive integer. If this value is not specified, 10 is used as the base value.

Missing input values generate missing results.
Literal numeric values should not be quoted. Quoted values are treated as strings.
Multiple columns and wildcards are not supported.

Required?	Data Type	Example Value
No	String (column reference) or Integer or Decimal literal	`7`