The following mathematic functions are supported for UAF.
| Operator | Function |
|---|---|
| ABS | Uses the absolute value. |
| CEILING | Returns the smallest integral value that is not less than the float input argument for a float number consisting of integral.fractional components. |
| EXP | Raises e (the base of natural logarithms) to the power of the argument, where e = 2.71828182845905. |
| FLOOR | Returns the smallest integral value that is equal to or less than the float input argument. For a float number consisting of integral.fractional components. |
| LN | Computes the natural logarithm of the argument. |
| LOG | Computes the base 10 logarithm of an argument. |
| NANIFZERO | Converts data from zero to NaN (not a number) to avoid problems with division by zero. Only supported in the FORMULA parameter. |
| POWER | Returns base value raised to the power of exponent value. |
| RANDOM | Returns a random integer number for each row of the results table. |
| ROUND | Returns the numeric value rounded to the user-defined number of places to the right or left of the decimal point. |
| SIGN | Returns the sign of the numeric value. |
| SQRT | Computes the square root of an argument. |
| TRUNC | Returns the numeric value of the user-defined truncated places to the right or left of the decimal point. |
| ZEROIFNAN | Converts data from NaN to 0 to avoid cases where a NaN result creates an error. Only supported in the FORMULA parameter. |
The following trigonometric functions are supported for UAF.
| Operator | Function |
|---|---|
| COS | Cosine of argument in radians in the range -1 to 1, inclusive. |
| SIN | Sine of argument in radians in the range -1 to 1, inclusive. |
| TAN | Tangent of argument in radians. |
| ACOS | Arccosine in the range 0 to π radians, inclusive. |
| ASIN | Arcsine in the range -π /2 to π /2 radians, inclusive. |
| ATAN | Arctangent in the range -π /2 to π /2 radians, inclusive. |
| ATAN2 | ATAN2(x,y) between -π and π radians, excluding -π. A positive result represents a counterclockwise angle from the x-axis. A negative result represents a clockwise angle. |
| COSH | Hyperbolic cosine of argument. Performs the hyperbolic or inverse hyperbolic function of an argument. |
| SINH | Hyperbolic sine of argument. Performs the hyperbolic or inverse hyperbolic function of an argument. |
| TANH | Hyperbolic tangent of argument. Performs the hyperbolic or inverse hyperbolic function of an argument. |
| ACOSH | Inverse hyperbolic cosine of argument. Performs the hyperbolic or inverse hyperbolic function of an argument. |
| ASINH | Inverse hyperbolic sine of argument. Performs the hyperbolic or inverse hyperbolic function of an argument. |
| ATANH | Inverse hyperbolic tangent of argument. Performs the hyperbolic or inverse hyperbolic function of an argument. |
| DEGREES | Function to convert radians to degrees. |
| RADIANS | Function to convert degrees to radians. |