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.

Numeric literal example:

derive type:single value: EXP(1)

Output: Generates a column containing the value of e 1, 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)

ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal to apply to the function


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

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

Example - Exponential functions