Computes the value of the first argument raised to the value of the second argument. 

Each argument can be a Decimal or Integer literal or a reference to a column containing numeric values.

Numeric literal example:

pow(10,3)

Output: Returns the value of 10 3, which is 1000.

Column reference example:

pow(MyValue,2)

Output: Returns the value of the MyValue column raised to the power of 2 (squared). 

pow(base_numeric_value, exp_numeric_value)


ArgumentRequired?Data TypeDescription
base_numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal that is the base value to be raised to the power of the second argument
exp_numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal that is the power to which to raise the base value

base_numeric_value

Name of the column or numeric literal whose values are used as the bases for the exponential computation.

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal2.3

exp_numeric_value

Name of the column or numeric literal whose values are used as the power to which the base-numeric value is raised. 

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal5

Example - Exponential functions

Example - Pythagorean Theorem