POW
Description
POW
is a row function that raises the a numeric value to the power (exponent) of another numeric value and returns a value of type DOUBLE
.Syntax
POW
(index
,power
)Return Value
Returns one value per row of type
DOUBLE
.Input Parameters
- index
- Required. A field or expression of a numeric type.
- power
- Required. A field or expression of a numeric type.
Examples
Calculate the compound annual growth rate (CAGR) percentage for a given investment over a five year span.
100 * POW([end_value]/[start_value], 0.2) - 1
Calculate the square of the
Value
field.POW([Value],2)
Calculate the square root of the
Value
field.POW([Value],0.5)
The following expression returns 1.
POW(0,0)