LOG

The LOG function returns the logarithm of a number for the given base specified in second parameter of the LOG function. If the base value is omitted, base 10 is used.

The LOG function has the following format:

LOG(n,b)
  • n is any positive value
  • b is base, b is any positive value other than 0 or 1

Syntax

SELECT LOG(…)  
SELECT LOG(number, base)

Examples

SELECT LOG(10, 1/12)
SELECT LOG(SUM(Amount), 2)
SELECT LOG(Amount[Max] * 400, Amount[Max])