Power ^

Operator: ^

The Power operator (or exponentiation) ^ is used to calculate a number raised to a given power.

There is also a Power Function that can be used: Pow(value, power).

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a number that is the result of number1 raised to a given power (number2).

If any of the operands is an unknown-number, the result is unknown. If any of the operands is not a number, expression editor yields a type mismatch warning.

value1 ^ value2

3 ^ 3 => 27

1234 ^ 1234 => infinity

-0.5 ^ 0.5 => Not a Number (NaN)

3 ^ "e" => expression type mismatch