Filemaker Pro 8.5 Educational Maintenance T1 TJ086LL/A User Manual

Chapter 2

  

|

  Aggregate functions     19

When a referenced field is a repeating field, the Average function returns the 

average of the values in the first repetition field, then the average of the values in the 
second repetition field, and so on. Therefore, 

.

Count(field{;field...})

field - any 

, 

; or an 

that returns a field, repeating field, or set of non-repeating fields.
Parameters in curly braces { } are optional.

number

Returns the number of valid, non-blank values in field where field can be any of the 

following:
•

a repeating field (repeatingField).

•

a field in matching 

 specified by (table::field), whether or not 

these records appear in a 

.

•

several non-repeating fields in a record (field1;field2;field3...).

•

corresponding repetitions of repeating fields in a 

(repeatingField1;repeatingField2;repeatingField3), if the result is 

returned in a repeating field with at least the same number of repeats.

•

several fields in the first matching record specified by 
(table::field1;table::field2;...). You can include fields from different 

 (table 1::field A;table 2::field B...).

 has a portal showing installment payments made. 

Count(Payments::Payment) returns the number of payments made on an account.
In the following examples:
•

Field1 contains two repetitions with values of 1 and 2. 

•

Field2 contains four repetitions with values of 5, 6, 7, and 8. 

•

Field3 contains 6. 

Count(Field2) returns 

 when the calculation isn’t a repeating field.