Relational Statistical Operators are used to generate statistical information on the values in the specified field in a set of records in a related table (i.e., a set of records that are related to the record currently being processed, such as all the reservations for an individual member).
Syntax
relational statistical operator TABLENAME|RELATIONSHIP
[named "UNIQUE RELATIONSHIP NAME" ]
[with ( selection criteria ) paren ] FIELDNAME ;
To generate statistics on a field in a related table:
Insert the Relational Statistical Operator followed by the name of the related table or the name of the relationship.
Assign a unique name to the relationship if necessary using the named operator.
Insert any desired selection criteria in parentheses.
Insert the field name followed by a semicolon or a period, depending on the location of the statement in the script.
The Relational Statistical Operators are: count of, highest of, lowest of, mean of, and sum of.
The count of operator counts the number of related records, not field values. The field name is omitted at the end of the count of statement.
The highest of and lowest of operators can be used on both Text and Number fields. highest of returns the highest ASCII field value in the set of related records. lowest of returns the lowest ASCII field value.
The sum of and mean of operators are used on Number fields. sum of returns the total of the field values in the set of related records. mean of returns the average of the field values in the set of related records.
Each Relational Statistical Operator is treated as a separate entry in this Language Reference.