: (colon)

: (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:



Last Name


Total Due

Adams


85.00

Albert


120.00

Anders


120.00

Andersen


70.00

Anderson


115.00

Archer


155.00

Baldwin


100.00



TOTAL:


$765.00