You are here: Function Reference > Mathematical Functions

Mathematical Functions

Mathematical functions perform certain mathematical operations and return the resulting value. The mathematical functions you can use are listed below. Click on the function name to jump to a discussion of that function.

Function	Result
ABS	Returns the absolute value of a number.
Avg	Averages a group of fields that share a naming method and returns the result.
Count	Counts the number of fields with values, shares a naming method, and returns the result.
INT	Returns the integer portion of a number.
MOD	Returns the remainder from modular arithmetic.
Numeric	Tests if a string contains a valid numeric value and returns one (1) if it does or zero (0) if it does not.
POW	Handles calculations such as those needed to figure annuities and interests rates.
SUM	Totals all fields that share a naming method and returns the result.

Note

DAL has a limit of 14 significant numbers. If you have a number with greater than 14 significant numbers and apply a DAL mathematical function to it, DAL will return a value of zero (0) for that number.

Open table of contents