Table of Contents

5 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 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 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)