Computes the logarithm of the first argument with a base of the second argument. |
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.
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, |
Required? | Data Type | Example Value |
---|---|---|
No | String (column reference) or Integer or Decimal literal | 7 |