Filter
Top Products
139
CLEM Language Reference
Function
Result
Description
mean_n(LIST)
Number
Returns the mean value from a list of numeric fields or null if
all of the field values are null.
sdev_n(LIST)
Number
Returns the standard deviation from a list of numeric fields
or null if all of the field values are null.
Trigonometr
ic Functions
All of the functions in this section either take an angle as an argument or return one as a result. In
both cases, the units of the angle (radians or degrees) are c ontrolled by the setting of the relevant
stream option.
Function
Result
Description
arccos(NUM)
Real
Computes the arccosine of the specified angle.
arccosh(NUM
)
Real
Computes the hyperbolic arccosine of the specified angle.
arcsin(NUM)
Real
Computes the arcsine of the specified angle.
arcsinh(NUM)
Real
Computes the hyperbolic arcsine of the specified angle.
arctan(NUM)
Real
Computes the arctangent of the specified angle.
arctan2(NUM_Y,
NUM_X)
Real
Computes the arctangent of NUM_Y / NUM_X and uses the
signs of the two numbers to derive quadrant information. The
result is a real in the range - pi < ANGLE <= pi (radians) – 180 <
ANGLE <= 180 (degrees)
arctanh(NUM)
Real
Computes the hyperbolic arctangent of the specified angle.
cos(NUM)
Real
Computes the cosine of the specified angle.
cosh(NUM)
Real
Computes the hyperbolic cosine of the specified angle.
pi
Real
This constant is the best real app roximation to pi.
sin(NUM)
Real
Computes the sine of the s pecified angle.
sinh(NUM)
Real
Computes the hyperbolic sine of the specified angle.
tan(NUM)
Real
Computes the tang ent of the specified angle.
tanh(NUM)
Real
Computes the hyperbolic tangent of the specified angle.
Probability Functions
Probability functions return probabilities based on various distributions, such as the probability
that a value from Student’s t distribution will be less than a specific value.
Function
Result
Description
cdf_chisq(NUM, DF)
Real
Returns the probability that a value from the chi-square
distribution with the specified degrees of freedom will
be less than the specified number.
cdf_f(NUM, DF1, DF2)
Real
Returns the probabil i t y that a value from the F
distribution, with degrees of freedom DF1 and DF2,
will be less than the specified number.