: (colon)

Type

Punctuation Symbol

Purpose

A colon is inserted between a field name and one or more statistical operators when you want to include statistics in the report output.

Syntax

FIELDNAME : statistical operators ;|.

Example

for MEMBERS ;

list records

LAST NAME in order ;

TOTAL DUE : item sum .

end

This script tells DataEase: list the MEMBERS records showing each member's LAST NAME, TOTAL DUE, and the total of all the TOTAL DUE values at the end of the report. The report output for this script, arranged in alphabetical order by LAST NAME, might look as follows: