Scalar functions
Mathematical functions
Function Name | Description |
---|---|
abs() | Calculates the absolute value of the input. |
acos() | Returns the angle whose cosine is the specified number (the inverse operation of cos()). |
asin() | Returns the angle whose sine is the specified number (the inverse operation of sin()). |
atan() | Returns the angle whose tangent is the specified number (the inverse operation of tan()). |
atan2() | Calculates the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x). |
cos() | Returns the cosine function. |
degrees() | Converts angle value in radians into value in degrees, using formula degrees = (180 / PI) * angle-in-radians. |
exp() | The base-e exponential function of x, which is e raised to the power x: e^x. |
exp2() | The base-2 exponential function of x, which is 2 raised to the power x: 2^x. |
gamma() | Computes gamma function. |
isinf() | Returns whether input is an infinite (positive or negative) value. |
isnan() | Returns whether input is Not-a-Number (NaN) value. |
log() | Returns the natural logarithm function. |
log10() | Returns the common (base-10) logarithm function. |
log2() | Returns the base-2 logarithm function. |
loggamma() | Computes log of absolute value of the gamma function. |
not() | Reverses the value of its bool argument. |
pi() | Returns the constant value of Pi (π). |
pow() | Returns a result of raising to power. |
radians() | Converts angle value in degrees into value in radians, using formula radians = (PI / 180) * angle-in-degrees. |
round() | Returns the rounded source to the specified precision. |
sign() | Sign of a numeric expression. |
sin() | Returns the sine function. |
sqrt() | Returns the square root function. |
tan() | Returns the tangent function. |
exp10() | The base-10 exponential function of x, which is 10 raised to the power x: 10^x. |
isint() | Returns whether input is an integer (positive or negative) value |
isfinite() | Returns whether input is a finite value (is neither infinite nor NaN). |
abs()
Calculates the absolute value of the input.
Arguments
- x: An integer or real number, or a timespan value.
Returns
- Absolute value of x.
Example
abs(x)
acos()
Returns the angle whose cosine is the specified number (the inverse operation of cos()) .
Arguments
x:
A real number in range [-1, 1].
Returns
- The value of the arc cosine of x
null
ifx
< -1 orx
> 1
Example
acos(x)
asin()
Returns the angle whose sine is the specified number (the inverse operation of sin()) .
Arguments
- x: A real number in range [-1, 1].
Returns
- The value of the arc sine of x
- null if x < -1 or x > 1
Example
asin(x)
atan()
Returns the angle whose tangent is the specified number (the inverse operation of tan()) .
Arguments
x: A real number.
Returns
The value of the arc tangent of x
Example
atan(x)
atan2()
Calculates the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x).
Arguments
x: X coordinate (a real number). y: Y coordinate (a real number).
Returns
The angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x).
Example
atan2(y,x)
cos()
Returns the cosine function.
Arguments
x: A real number.
Returns
The result of cos(x)
Example
cos(x)
degrees()
Converts angle value in radians into value in degrees, using formula degrees = (180 / PI ) * angle_in_radians
Arguments
a: Angle in radians (a real number).
Returns
The corresponding angle in degrees for an angle specified in radians.
Examples
degrees(a)
exp()
The base-e exponential function of x, which is e raised to the power x: e^x.
Example
exp(x)
Arguments
x: A real number, value of the exponent.
Returns
- Exponential value of x.
- For natural (base-e) logarithms, see log().
- For exponential functions of base-2 and base-10 logarithms, see exp2(), exp10()
exp2()
The base-2 exponential function of x, which is 2 raised to the power x: 2^x.
Example
exp2(x)
Arguments
x: A real number, value of the exponent.
Returns
- Exponential value of x.
- For natural (base-2) logarithms, see log2().
- For exponential functions of base-e and base-10 logarithms, see exp(), exp10()
gamma()
Computes gamma function
Example
gamma(x)
Arguments
- x: Parameter for the gamma function
Returns
- Gamma function of x.
- For computing log-gamma function, see loggamma().
isinf()
Returns whether input is an infinite (positive or negative) value.
Example
isinf(x)
Arguments
x: A real number.
Returns
A non-zero value (true) if x is a positive or negative infinite; and zero (false) otherwise.
isnan()
Returns whether input is Not-a-Number (NaN) value.
Example
isnan(x)
Arguments
x: A real number.
Returns
A non-zero value (true) if x is NaN; and zero (false) otherwise.
log()
log() returns the natural logarithm function.
Example
log(x)
Arguments
x: A real number > 0.
Returns
The natural logarithm is the base-e logarithm: the inverse of the natural exponential function (exp). null if the argument is negative or null or can't be converted to a real value.
log10()
log10() returns the common (base-10) logarithm function.
Example
log10(x)
Arguments
x: A real number > 0.
Returns
The common logarithm is the base-10 logarithm: the inverse of the exponential function (exp) with base 10. null if the argument is negative or null or can't be converted to a real value.
log2()
log2() returns the base-2 logarithm function.
Example
log2(x)
Arguments
x: A real number > 0.
Returns
The logarithm is the base-2 logarithm: the inverse of the exponential function (exp) with base 2. null if the argument is negative or null or can't be converted to a real value.
loggamma()
Computes log of absolute value of the gamma function
Example
loggamma(x)
Arguments
x: Parameter for the gamma function
Returns
- Returns the natural logarithm of the absolute value of the gamma function of x.
not()
Reverses the value of its bool argument.
Example
not(expr)
Arguments
expr: A bool expression to be reversed.
Returns
Returns the reversed logical value of its bool argument.
pi()
Returns the constant value of Pi.
Example
pi()
Returns
- The double value of Pi (3.1415926...)
pow()
Returns a result of raising to power
Example
pow(base, exponent )
Arguments
- base: Base value.
- exponent: Exponent value.
Returns
Returns base raised to the power exponent: base ^ exponent.
radians()
Converts angle value in degrees into value in radians, using formula radians = (PI / 180 ) * angle_in_degrees
Example
radians(a)
Arguments
a: Angle in degrees (a real number).
Returns
The corresponding angle in radians for an angle specified in degrees.
round()
Returns the rounded source to the specified precision.
Example
round(source [, Precision])
Arguments
- source: The source scalar the round is calculated on.
- Precision: Number of digits the source will be rounded to.(default value is 0)
Returns
The rounded source to the specified precision.
sign()
Sign of a numeric expression
Example
sign(x)
Arguments
- x: A real number.
Returns
- The positive (+1), zero (0), or negative (-1) sign of the specified expression.
sin()
Returns the sine function.
Example
sin(x)
Arguments
x: A real number.
Returns
The result of sin(x)
sqrt()
Returns the square root function.
Example
sqrt(x)
Arguments
x: A real number >= 0.
Returns
- A positive number such that sqrt(x) sqrt(x) == x*
- null if the argument is negative or cannot be converted to a real value.
tan()
Returns the tangent function.
Example
tan(x)
Argument
- x: A real number.
Returns
- The result of
tan(x)
exp10()
The base-10 exponential function of x, which is 10 raised to the power x: 10^x.
Example
exp10(x)
Arguments
x: A real number, value of the exponent.
Returns
- Exponential value of x.
- For natural (base-10) logarithms, see log10().
- For exponential functions of base-e and base-2 logarithms, see exp(), exp2()
isint()
Returns whether input is an integer (positive or negative) value.
Arguments
- Expr: expression value which can be a real number
Returns
A non-zero value (true) if expression is a positive or negative integer; and zero (false) otherwise.
Example
isint(expression)
isint(resp_body_size_bytes) == true
isfinite()
Returns whether input is a finite value (is neither infinite nor NaN).
Arguments
- number: A real number.
Returns
A non-zero value (true) if x is finite; and zero (false) otherwise.
Example
isfinite(number)