[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 AVERAGE
 Average numeric expressions in the current work area
------------------------------------------------------------------------------
 Syntax

     AVERAGE <nExp list> TO <idVar list>
        [<scope>] [WHILE <lCondition>] [FOR <lCondition>]

 Arguments

     <nExp list> is a list of the numeric values to AVERAGE for each
     record processed.

     TO <idVar list> identifies a list of receiving variables which will
     contain the average results.  Variables that either do not exist or are
     not visible are created as private variables.  <idVar list> must contain
     the same number of elements as <nExp list>.

     <scope> defines the portion of the current database file to AVERAGE.
     The default scope is ALL.

     WHILE <lCondition> specifies the set of records meeting the
     condition from the current record until the condition fails.

     FOR <lCondition> specifies the conditional set of records to AVERAGE
     within the given scope.

 Description

     AVERAGE calculates the average of one or more numeric expressions to
     variables for a range of records in the current database file.  Zero
     values are counted in the AVERAGE unless explicitly ruled out with a FOR
     condition.

 Examples

     .  This example averages a single numeric field using a condition
        to select a subset of records from the database file:

        USE Sales NEW
        AVERAGE Amount TO nAvgAmount FOR Branch = "100"

     .  This example finds the average date for a range of dates:

        AVERAGE (SaleDate - CTOD("00/00/00")) ;
           TO nAvgDays FOR !EMPTY(SaleDate)
        dAvgDate := CTOD("00/00/00") + nAvgDays

 Files   Library is CLIPPER.LIB.


See Also: DBEVAL() SUM TOTAL
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson