In these general numeric functions, the arguments are expressions where x
should be interpreted as a real valued number. All functions can be used in both data load scripts and chart expressions.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
BitCount() returns how many bits in the binary equivalent of a decimal number are set to 1. That is, the function returns the number of set bits in integer_number, where integer_number is interpreted as a signed
32-bit integer.
Div() returns the integer part of the arithmetic division of the first argument by the second argument. Both parameters are interpreted as real numbers, that is,
they do not have to be integers.
Combin() returns the number of combinations of q
elements that can be picked from a set of p items. As represented by the formula: Combin(p,q) = p! / q!(p-q)! The order in which the items are selected is insignificant.
Permut() returns the number of permutations of q elements that can be selected from a set of p items. As represented by the formula: Permut(p,q) = (p)! / (p - q)! The order in which the items are selected is significant.
fmod() is a generalized modulo function that returns the remainder part of the integer division of the first argument (the dividend) by the second argument (the divisor). The result is a real number. Both arguments are interpreted as real
numbers, that is, they do not have to be integers.
Mod() is a mathematical modulo function that returns the non-negative remainder of an integer division. The first argument is the dividend, the second argument is the divisor, Both arguments must be integer values.
Even() returns True (-1), if integer_number is an even integer or zero. It returns False (0), if integer_number is an odd
integer, and NULL if integer_number is not
an integer.
Odd() returns True (-1), if integer_number is an odd
integer or zero. It returns False (0), if integer_number is an even integer, and NULL if integer_number is not
an integer.