General Numeric Functions |
Table: General Numeric Functions lists the OLAP DML functions for calculation.
General Numeric Functions
| Function | Description |
|---|---|
| ABS
|
Calculates the absolute value of an expression. |
| ANTILOG
|
Calculates the value of e (the base of natural logarithms) raised to a specific power. |
| ANTILOG10
|
Calculates the value of 10 raised to a specified power. |
| ARCCOS
|
Calculates the angle value (in radians) of a specified cosine. |
| ARCSIN
|
Calculates the angle value (in radians) of a specified sine. |
| ARCTAN
|
Calculates the angle value (in radians) of a specified tangent. |
| ARCTAN2
|
Returns a full-range (0 - 2 pi) numeric value indicating the arc tangent of a given ratio. |
| BITAND
|
Computes an AND operation on the bits of two INTEGER values.
|
| CEIL
|
Returns the smallest whole number greater than or equal to a specified number. |
| COS
|
Calculates the cosine of an angle expression. |
| COSH
|
Calculates the hyperbolic cosine of an angle expression. |
| DECODE
|
Compares one expression to one or more other expressions and, when the base expression is equal to a search expression, returns the corresponding result expression; or, when no match is found, returns the default expression when it is specified, or NA when it is not. |
| EXP
|
Returns e raised to the nth power, where e equals 2.71828183.... |
| FLOOR
|
Returns the largest whole number equal to or less than a specified number. |
| GREATEST
|
Returns the largest expression in a list of expressions. All expressions after the first are implicitly converted to the data type of the first expression before the comparison. |
| INSTRB
|
Calculates the integer part of a decimal number by truncating its decimal fraction. |
| LEAST
|
Returns the smallest expression in a list of expressions. All expressions after the first are implicitly converted to the data type of the first expression before the comparison. |
| LOG function
|
Computes the natural logarithm of an expression. |
| LOG10
|
Computes the logarithm base 10 of an expression. |
| MAX
|
Calculates the larger value of two expressions. |
| MIN
|
Calculates the smaller value of two expressions. |
| NULLIF
|
Compares one expression with another and returns NA when the expressions are equal, or the base expression when they are not. |
| REM
|
Returns the remainder after one numeric expression is divided by another. |
| ROUND (for numbers)
|
Returns the number rounded to the nearest multiple of a second number you specify or to the number of decimal places indicated by the second number. |
| SIGN
|
Returns a value that indicates if a specified number is less than, equal to, or greater than 0 (zero). |
| SIN
|
Calculates the sine of an angle expression. The result returned by SIN is a decimal value with the same dimensions as the specified expression. |
| SINH
|
Calculates the hyperbolic sine of an angle expression. |
| SQRT
|
Computes the square root of an expression. |
| TAN
|
Calculates the tangent of an angle expression. |
| TANH
|
Calculates the hyperbolic tangent of an angle expression. |
| TRUNC (for numbers)
|
Truncates a number to a specified number of decimal places. |
| WIDTH_BUCKET
|
Returns the bucket number into which the value of an expression would fall after being evaluated. |