Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc
Excerpt

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.

D s
snippetBasic

Numeric literal example:

D code

derive value: POW(10,3)

Output: Generates a column containing the value of 103, which is 1000.

Column reference example:

D code

derive value: POW(MyValue,2) as: 'sqred_MyValue'

Output: Generates the new sqred_myValue column containing the value of the MyValue column raised to the power of 2 (squared). 

D s
snippetSyntax

D code

derive value: 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

d-s-lang-notes

base_numeric_value

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

  • Missing input values generate missing results.
  • Literal numeric values should not be quoted. 
  • Multiple columns and wildcards are not supported.

D s
snippetusage

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. 

  • Missing input values generate missing results.
  • Literal numeric values should not be quoted. 
  • Multiple columns and wildcards are not supported.

D s
snippetusage

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

D s
snippetExamples

Example - Exponential functions

Include Page
EXAMPLE - Exponentional Functions
EXAMPLE - Exponentional Functions

Example - Pythagorean Theorem

Include Page
EXAMPLE - POW and SQRT Functions
EXAMPLE - POW and SQRT Functions

D s also
labelmath