percent

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:

Total Due greater than $100 = 22%