Math

Math functions perform a variety of different mathematical calculations.

Function descriptions

Function	Description
ABS( )	Returns the absolute value of a numeric expression. The absolute value of a number is the number without its sign.
COS( )	Returns the cosine of an angle expressed in radians, with a precision of 15 decimal places.
DEC( )	Returns a value, or the result of a numeric expression, with the specified number of decimal places.
EXP( )	Returns the exponential value (base 10) of a numeric expression with a specified number of decimal places.
FREQUENCY( )	Returns the expected Benford frequency for sequential leading positive numeric digits to a precision of eight decimal places.
INT( )	Returns the integer value of a numeric expression or field value.
LEADING( )	Returns a string containing a specified number of leading digits.
LOG( )	Returns the logarithm (base 10) of a numeric expression or field value with a specified number of decimal places.
MAXIMUM( )	Returns the maximum value in a set of numeric values, or the most recent value in a set of datetime values.
MINIMUM( )	Returns the minimum value in a set of numeric values, or the oldest value in a set of datetime values.
MOD( )	Returns the remainder from dividing two numbers.
NORMDIST( )	Returns the probability that a random variable from a normally distributed data set is less than or equal to a specified value, or exactly equal to a specified value.
NORMSINV( )	Returns the z-score associated with a specified probability in a standard normal distribution. The z-score is the number of standard deviations a value is from the mean of a standard normal distribution.
PI( )	Returns the value of pi to 15 decimal places.
RAND( )	Returns a random number that falls within a specified boundary.
ROOT( )	Returns the square root of a numeric expression.
ROUND( )	Returns a rounded whole number for a numeric value.
SIN( )	Returns the sine of an angle expressed in radians, with a precision of 15 decimal places.
TAN( )	Returns the tangent of an angle expressed in radians, with a precision of 15 decimal places.
VALUE( )	Converts a character string to a numeric value.
ZONED( )	Converts numeric data to character data and adds leading zeros to the output.
ZSTAT( )	Returns the standard Z-statistic.

[ Back to top ]

ACL Scripting Guide 14.1