Table of Contents
6 Mathematical functions
All functions listed here are supported in:
Mathematical functions are supported with float and integer value types, unless stated otherwise.
Some general notes on function parameters:
- Function parameters are separated by a comma
- Expressions are accepted as parameters
- Optional function parameters (or parameter parts) are indicated by
<>
| FUNCTION | ||
|---|---|---|
| Description | Function-specific parameters | Comments |
| abs (value) | ||
| The absolute value of a value. | value - value to check | Supported value types: float, int, str, text, log For strings returns: 0 - values are equal 1 - values differ Example: => abs(last(/host/key))>10 Absolute numeric difference will be calculated, as seen with these incoming example values ('previous' and 'latest' value = absolute difference): '1' and '5' = 4'3' and '1' = 2'0' and '-2.5' = 2.5 |
| acos (value) | ||
| The arccosine of a value as an angle, expressed in radians. | value - value to check | The value must be between -1 and 1. For example, the arccosine of a value '0.5' will be '2.0943951'. Example: => acos(last(/host/key)) |
| asin (value) | ||
| The arcsine of a value as an angle, expressed in radians. | value - value to check | The value must be between -1 and 1. For example, the arcsine of a value '0.5' will be '-0.523598776'. Example: => asin(last(/host/key)) |
| atan (value) | ||
| The arctangent of a value as an angle, expressed in radians. | value - value to check | For example, the arctangent of a value '1' will be '0.785398163'. Example: => atan(last(/host/key)) |
| atan2 (value,abscissa) | ||
| The arctangent of the ordinate (exprue) and abscissa coordinates specified as an angle, expressed in radians. | value - value to check abscissa - abscissa value |
For example, the arctangent of the ordinate and abscissa coordinates of a value '1' will be '2.21429744'. Example: => atan2(last(/host/key),2) |
| avg (<value1>,<value2>,...) | ||
| Average value of the referenced item values. | valueX - value returned by one of history functions | Example: => avg(avg(/host/key),avg(/host2/key2)) |
| cbrt (value) | ||
| Cube root of a value. | value - value to check | For example, the cube root of '64' will be '4', of '63' will be '3.97905721'. Example: => cbrt(last(/host/key)) |
| ceil (value) | ||
| Round the value up to the nearest greater or equal integer. | value - value to check | For example, '2.4' will be rounded up to '3'. Example: => ceil(last(/host/key)) See also floor(). |
| cos (value) | ||
| The cosine of a value, where the value is an angle expressed in radians. | value - value to check | For example, the cosine of a value '1' will be '0.54030230586'. Example: => cos(last(/host/key)) |
| cosh (value) | ||
| The hyperbolic cosine of a value. | value - value to check | For example, the hyperbolic cosine of a value '1' will be '1.54308063482'. Returns value as a real number, not as scientific notation. Example: => cosh(last(/host/key)) |
| cot (value) | ||
| The cotangent of a value, where the value is an angle, expressed in radians. | value - value to check | For example, the cotangent of a value '1' will be '0.54030230586'. Example: => cot(last(/host/key)) |
| degrees (value) | ||
| Converts a value from radians to degrees. | value - value to check | For example, a value '1' converted to degrees will be '57.2957795'. Example: => degrees(last(/host/key)) |
| e | ||
| Euler's number (2.718281828459045). | Example: => e() |
|
| exp (value) | ||
| Euler's number at a power of a value. | value - value to check | For example, Euler's number at a power of a value '2' will be '7.38905609893065'. Example: => exp(last(/host/key)) |
| expm1 (value) | ||
| Euler's number at a power of a value minus 1. | value - value to check | For example, Euler's number at a power of a value '2' minus 1 will be '6.38905609893065'. Example: => expm1(last(/host/key)) |
| floor (value) | ||
| Round the value down to the nearest smaller or equal integer. | value - value to check | For example, '2.6' will be rounded down to '2'. Example: => floor(last(/host/key)) See also ceil(). |
| log (value) | ||
| Natural logarithm. | value - value to check | For example, the natural logarithm of a value '2' will be '0.69314718055994529'. Example: => log(last(/host/key)) |
| log10 (value) | ||
| Decimal logarithm. | value - value to check | For example, the decimal logarithm of a value '5' will be '0.69897000433'. Example: => log10(last(/host/key)) |
| max (<value1>,<value2>,...) | ||
| Highest value of the referenced item values. | valueX - value returned by one of history functions | Example: => max(avg(/host/key),avg(/host2/key2)) |
| min (<value1>,<value2>,...) | ||
| Lowest value of the referenced item values. | valueX - value returned by one of history functions | Example: => min(avg(/host/key),avg(/host2/key2)) |
| mod (value,denominator) | ||
| Division remainder. | value - value to check denominator - division denominator |
For example, division remainder of a value '5' with division denominator '2' will be '1'. Example: => mod(last(/host/key),2) |
| pi | ||
| Pi constant (3.14159265358979). | Example: => pi() |
|
| power (value,power value) | ||
| The power of a value. | value - value to check power value - the Nth power to use |
For example, the 3rd power of a value '2' will be '8'. Example: => power(last(/host/key),3) |
| radians (value) | ||
| Convert a value from degrees to radians. | value - value to check | For example, a value '1' converted to radians will be '0.0174532925'. Example: => radians(last(/host/key)) |
| rand | ||
| Return a random integer value. | A pseudo-random generated number using time as seed (enough for mathematical purposes, but not cryptography). Example: => rand() |
|
| round (value,decimal places) | ||
| Round the value to decimal places. | value - value to check decimal places - specify decimal places for rounding (0 is also possible) |
For example, a value '2.5482' rounded to 2 decimal places will be '2.55'. Example: => round(last(/host/key),2) |
| signum (value) | ||
| Returns '-1' if a value is negative, '0' if a value is zero, '1' if a value is positive. | value - value to check | Example: => signum(last(/host/key)) |
| sin (value) | ||
| The sine of a value, where the value is an angle expressed in radians. | value - value to check | For example, the sine of a value '1' will be '0.8414709848'. Example: => sin(last(/host/key)) |
| sinh (value) | ||
| The hyperbolical sine of a value. | value - value to check | For example, the hyperbolical sine of a value '1' will be '1.17520119364'. Example: => sinh(last(/host/key)) |
| sqrt (value) | ||
| Square root of a value. | value - value to check | This function will fail with a negative value. For example, the square root of a value '3.5' will be '1.87082869339'. Example: => sqrt(last(/host/key)) |
| sum (<value1>,<value2>,...) | ||
| Sum of the referenced item values. | valueX - value returned by one of history functions | Example: => sum(avg(/host/key),avg(/host2/key2)) |
| tan (value) | ||
| The tangent of a value. | value - value to check | For example, the tangent of a value '1' will be '1.55740772465'. Example: => tan(last(/host/key)) |
| truncate (value,decimal places) | ||
| Truncate the value to decimal places. | value - value to check decimal places - specify decimal places for truncating (0 is also possible) |
Example: => truncate(last(/host/key),2) |