Simplicty and flexibility!


Support::

Statistical Operators


Parameters


Returns/Result


Examples


Reference

Statistical Operators

Statistical Operators

Type

Operator

Purpose

Statistical Operators (shown at right) are used to generate statistical information on numeric fields that appear as list items in a script.

Syntax

FIELDNAME : statistical operator

Usage

To generate statistics on a field:

  • Insert the fieldname followed by a colon.

  • After the colon, insert the appropriate statistical operators.

  • After the last operator, insert a semicolon or a period, depending on the location of the operator in the script.

 

Statistical Operators can be used on any type of numeric field (Currency, Integer, Fixed Point, and Floating Point). They cannot be used on Numeric String fields.

You may use as many operators as you want on a given field, one after another, separating each by a space.

If you use a statistical operator and you want the field value listed in addition to the statistical information, you must include the item operator after the field name.

The statistical operators are: item, max, mean, min, std. dev., std. err., sum, and variance. Each statistical operator is treated as a separate entry in this Language Reference.

See Also


On the forum about Statistical Operators

[@EOF@]...

Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 è poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

How can i delete a Style sheet?...

Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10

I run W7 and since a few days&nbsp;Dataease 8.5 is not starting any more, do you have an idea? i installed it again but that did not help....

Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40

[@EOF@]...

Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10

On the blog about Statistical Operators


dg3_HelpView