Register
Sign In
Conditional Statistical Operator
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
TOTAL DUE ;
TOTAL DUE > 100 : item percent .
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%
Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32
Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17
Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11
Product: . Written by Marco Marchesi 15/02/16 at 14:50:46
Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46
Product: . Written by afonso santos 28/10/19 at 00:50:14
Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44
Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10
Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40
Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10
Copyright © DataEase Limited. All Rights Reserved
