CDO$HELP.HLB  —  Expressions  value_expr, Parameters  statistical-expr
    {                        }
    { { MAX     }            }
    { { MIN     }            }
    { { TOTAL   } value-expr } OF rse
    { { AVERAGE }            }
    {                        }
    { COUNT                  }
    {                        }

    Specifies a value by forming a record stream (as indicated
    by a record selection expression), and evaluating its value
    expression against every record in the record stream. Statistical
    expressions are sometimes called aggregate expressions because
    they calculate a single value for a collection of records. When
    you use a statistical expression (except for COUNT), you specify
    a value expression and an RSE. A layered product evaluates the
    value expression for each record in the record stream formed by
    the RSE. Then the product calculates a single value based on the
    results of the first step.

    The COUNT expression differs from the other statistical operators
    because it operates on the record stream defined by the RSE,
    rather than on values in that record stream. It returns the
    number of records in the record stream. In the following
    expression, the number of employees working in New Hampshire
    is returned.

    COUNT OF E IN EMPLOYEES WITH STATE IN E = "NH"
Close Help