OPAL Numeric Functions¶
Function |
Description |
---|---|
Returns the absolute value of ‘val’. |
|
returns the number of elements in an array, or null… |
|
Calculate the arithmetic average of the input… |
|
Returns ‘val’ rounded up to the given ‘precision’…. |
|
Count the number of non-null items in the group. |
|
Estimate the approximate number of distinct values… |
|
Count the exact number of distinct values in the… |
|
Returns the dense rank within an ordered group of… |
|
Calculate the average per-second derivative of the… |
|
Returns Euler’s number e raised to the given number. |
|
Generate a float representation of the argument value. |
|
Returns a null value of type float64. This is… |
|
Returns ‘val’ rounded down to the given ‘precision’…. |
|
Accepts a variable number of arguments of arbitrary… |
|
Computes the great circle approximate distance… |
|
Generate a int representation of the argument value…. |
|
Returns a null value of type int64. This is importan… |
|
Returns natural logarithm of a numeric expression…. |
|
Returns logarithm of a numeric expression (second… |
|
Return the fast approximate median value of one… |
|
Returns the the remainder when dividend is divided… |
|
Returns a null value of type numeric. This is… |
|
Parses a string encoded hex number and returns an… |
|
Returns an approximated value for the specified… |
|
Assuming a continuous distribution, it returns the… |
|
Assuming a discrete distribution, it returns the… |
|
Returns a number ‘base’ raised to the specified… |
|
Returns the rank within an ordered group of values…. |
|
Calculate the average per-second rate of the… |
|
Returns ‘val’ rounded to the given ‘precision’…. |
|
Return the window index of the row within its… |
|
Returns the square root for a given input and null… |
|
Calculate the standard deviation across the group. |
|
Compute the length of an input string. |