Numeric Functions
CSL supports the following predefined numeric functions.
abs(x)
Returns the absolute value of x. The argument must be numeric.
acos(x)
Returns the arccosine of x in degrees.
asin(x)
Returns the arcsine of x in degrees.
atan(x)
Returns the arctangent of x in degrees.
cos(x)
Returns the cosine of the angle specified in degrees by x.
divZero(x, y)
Returns x/y if y <> 0; returns 0 otherwise.
equalsEps(x, y, z)
Returns true if abs(x - y) is strictly less than z; returns false otherwise
exp(x)
Returns the mathematical constant e raised to the x power.
interpolate(x, x0, x1, y0, y1)
Returns the y-coordinate of the point on the specified line whose x-coordinate is x. The specified line is the line containing both the points (x0, y0) and (x1, y1). If x0 equals x1, the function returns y0.
len(x)
Returns the cardinality of the collection x. An exception is thrown if x is not a collection.
ln(x)
Returns the natural logarithm of x.
max(x, y, z, ...)
Returns the maximum of the specified values.
maxNonNegativeNumber(x, y, z, ...)
Returns the maximum of the specified values, excluding negative numbers. If no argument is a non-negative number, invalidScriptException is thrown.
min(x, y, z, ...)
Returns the minimum of the specified values.
minNonNegativeNumber(x, y, z, ...)
Returns the minimum of the specified values, excluding negative numbers. If no argument is a non-negative number, invalidScriptException is thrown.
round(x)
Return the natural rounded value of (that is, the nearest integer to) x. As usual, for any integer, n, values in the interval [n - 0.5, n + 0.5) round to n.
roundEps(x, y)
Return the value of rounding x, naturally, to the precision specified by y. Examples:
• roundEps(1.45, 0.1) returns 1.5
• roundEps(1.44, 0.1) returns 1.4
rounddown(x)
Return the greatest integer less than or equal to x (that is, returns the integer value of x, or floor of x).
roundup(x)
Returns the least integer greater than or equal to x (that is, returns ceiling of x).
sin(x)
Returns the sine of the angle specified in degrees by x.
sqrt(x)
Returns the positive square root of x.
sum(x, y, z, ...)
Returns the sum of arguments y, z, ... evaluated against all elements of the collection x.
tan(x)
Returns the tangent of the specified angle, x. The angle is specified in degrees.
getProperty(row, column)
Returns the value of the collection row for the attribute column.