Home > DQL Guide > DQL Lexicon > Statistical Operators
Statistical Operators (shown at right) are used to generate statistical information on numeric fields that appear as list items in a script.
Syntax
FIELDNAME : statistical operator
Usage
To generate statistics on a field:
Insert the fieldname followed by a colon.
After the colon, insert the appropriate statistical operators.
After the last operator, insert a semicolon or a period, depending on the location of the operator in the script.
Statistical Operators can be used on any type of numeric field (Currency, Integer, Fixed Point, and Floating Point). They cannot be used on Numeric String fields.
You may use as many operators as you want on a given field, one after another, separating each by a space.
If you use a statistical operator and you want the field value listed in addition to the statistical information, you must include the item operator after the field name.
The statistical operators are: item, max, mean, min, std. dev., std. err., sum, and variance. Each statistical operator is treated as a separate entry in this Language Reference.