AAVERAGE()

From Recital Documentation Wiki
Revision as of 16:53, 26 October 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(), ASCAN(), ASIZE(), ASORT(), ASTORE(), ASTRING(), ASUBSCRIPT(), ASUM(), COPY TO ARRAY, DECLARE, DIMENSION, GATHER, 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