Difference between revisions of "AAVERAGE()"
From Lianjapedia
(3 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to calculate the average of element values in an array | Function to calculate the average of element values in an array | ||
− | |||
==Syntax== | ==Syntax== | ||
AAVERAGE(<array>) | AAVERAGE(<array>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[AADD | + | [[AADD()]], [[ACOPY()]], [[ADEL()]], [[ADESC()]], [[ADIR()]], [[AELEMENT()]], [[AFIELDS()]], [[AFILL()]], [[AINS()]], [[ALEN()]], [[AMAX()]], [[AMIN()]], [[APPEND FROM ARRAY]], [[ARRAY()]], [[ASCAN()]], [[ASIZE()]], [[ASORT()]], [[ASTORE()]], [[ASTRING()]], [[ASUBSCRIPT()]], [[ASUM()]], [[COPY TO ARRAY]], [[DECLARE]], [[DIMENSION]], [[GATHER]], [[IN_ARRAY()]], [[IS_ARRAY()]], [[LOCAL]], [[PRIVATE]], [[PUBLIC]], [[RELEASE]], [[RESTORE]], [[SAVE]], [[SCATTER]] |
==Description== | ==Description== | ||
The AAVERAGE() function calculates the average of all the numeric elements in the specified <array> and returns the result. | The AAVERAGE() function calculates the average of all the numeric elements in the specified <array> and returns the result. | ||
− | |||
==Example== | ==Example== | ||
Line 23: | Line 20: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:Array Processing Functions]] | [[Category:Array Processing Functions]] | ||
+ | [[Category:Lianja VFP Extensions]] | ||
+ | [[Category:VFP Function Extensions]] |
Latest revision as of 06:51, 10 December 2012
Contents
Purpose
Function to calculate the average of element values in an array
Syntax
AAVERAGE(<array>)
See Also
AADD(), ACOPY(), ADEL(), ADESC(), ADIR(), AELEMENT(), AFIELDS(), AFILL(), AINS(), ALEN(), AMAX(), AMIN(), APPEND FROM ARRAY, ARRAY(), ASCAN(), ASIZE(), ASORT(), ASTORE(), ASTRING(), ASUBSCRIPT(), ASUM(), COPY TO ARRAY, DECLARE, DIMENSION, GATHER, IN_ARRAY(), IS_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