Average()

 <  Day Day Up  >  

Average()

Category: Aggregate

Syntax: Average ( field { ; field...} )

Parameters: field ”any related field, repeating field, or set of non-repeating fields that represent a collection of numbers . Parameters in curly braces {} are optional.

Description: Returns a numeric value that is the arithmetic mean of all non-blank values in the set designated by the parameter list. The arithmetic mean of a set of numbers is the sum of the numbers divided by the size of the set. Blank values are not considered as part of the set.

Examples:

 

 Average (field1 ; field2 ; field3 ) 

Returns 2 , when field1 = 1, field2 = 2, and field3 = 3.

 

 Average (repeatingField) 

Returns 2 , when repetition1 = 1, repetition2 = 2, and repetition3 = 3.

 

 Average (Customer::InvoiceTotal) 

Returns $450 , when a customer has three related invoice records with invoice totals of $300, $500, and $550.

Comments:

When the parameter list consists of 2 or more repeating fields, Average() generates a repeating field in which the corresponding repetitions from the specified fields are averaged separately. So, if a field Repeater1 has two values, 16 and 20, and another field, Repeater2 , has two values, 14 and 25, Average (Repeater1; Repeater2) would return a repeating field with values 15 and 22.5.

 <  Day Day Up  >  


QUE CORPORATION - Using Filemaker pro X
QUE CORPORATION - Using Filemaker pro X
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 494

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net