View Source

Computes the value of e raised to the specified power. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

e or Euler's Number is the value that the following equation approaches as n grows large: (1 + (1/ n)) ⁿ.

Numeric literal example:

derive type:single value: EXP(1)

Output: Generates a column containing the value of e ¹, which is approximately 2.718281828.

Column reference example:

derive type:single value: EXP(MyValue) as: 'exp_MyValue'

Output: Generates the new exp_MyInteger column containing the value of e to the power of the value in the MyValue column.

derive type:single value: EXP(numeric_value)

Argument	Required?	Data Type	Description
numeric_value	Y	string, decimal, or integer	Name of column or Decimal or Integer literal to apply to the function

numeric_value

Name of the column or numeric literal whose value is the exponent of e.

Missing input values generate missing results.
Literal numeric values should not be quoted. Quoted values are treated as strings.
Multiple columns and wildcards are not supported.

Required?	Data Type	Example Value
Yes	String (column reference) or Integer or Decimal literal	`2.3`

numeric_value

Example - Exponential functions