AAVERAGE()

From Recital Documentation Wiki
Revision as of 09:59, 5 November 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search

Purpose

Function to calculate the average of element values in an array


Syntax

AAVERAGE(<array>)


See Also

AADD(), ABROWSE(), ACHOICE(), ACOL(), ACOPY(), ADEL(), ADESC(), ADIR(), AELEMENT(), AFIELDS(), AFILL(), AINS(), ALEN(), AMAX(), AMIN(), APPEND FROM ARRAY, AROW(), ARRAY(), ASCAN(), ASIZE(), ASORT(), ASTORE(), ASTRING(), ASUBSCRIPT(), ASUM(), COPY TO ARRAY, DECLARE, DIMENSION, GATHER, IN_ARRAY(), LOCAL, PRIVATE, PUBLIC, RELEASE, RESTORE, SAVE, SCATTER

Description

The AAVERAGE() function calculates the average of all the numeric elements in the specified <array> and returns the result.


Example

use payroll
declare number[reccount(),1]
copy to array number fields pay_value
? aaverage(number)
   1741.01


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer