Type
Conditional Statistical Operator

Purpose
The percent operator calculates the percentage of records that satisfy a condition specified by a comparison of two values.

Syntax
CONDITION : percent [other conditional statistical operators]

Returns
A numeric value.

Example
for MEMBERS ;
list records
LAST NAME in order ;
TOTAL DUE ;
TOTAL DUE > 100 : item percent .
end

This query tells DataEase: (1) Process all the MEMBERS records and list each member's LAST NAME in alphabetical order, (2) list each member's TOTAL DUE, (3) for each member, display a YES or NO answer indicating if the TOTAL DUE is over $100, and (4)display the percentage of records that have a TOTAL DUE value greater than $100 in the report output.
The output from this query might look as follows:

Last Name
Total Due
Total Due greater than $100
Adams
$85.00
NO
Albert
$120.00
YES
Anders
$120.00
YES
Andersen
$70.00
NO
Anderson
$115.00
YES
Archer
$155.00
YES
Baldwin
$100.00
NO
Beauchamp...
$35.00...
NO...

Total Due greater than $100 = 22%