Filemaker Pro 8.5 Advanced Maintenance TG762Z/A User Manual

Count(Field1;Field2;Field3) returns 

, 

, 

,

 when the calculation is a repeating 

field.

When a referenced field is a repeating field, the Count function returns the total 

number of valid, non-blank values in the first repetition field, then the number of valid, non-
blank values in the second repetition field, and so on.

List(field{;field...})

field

 - any 

, 

; or an 

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

text

Returns a concatenated list of non-blank values (separated by carriage returns) for either:
•

a single field (table::field), calculates a single result over all repetitions (if any) 
for this field and over all matching related records, whether or not these records 
appear in a portal.

•

several fields and/or literal values 
(table::field1,constant,table::field2...)

, calculates a separate result 

for each repetition of the calculation across each corresponding repetition of the 
fields. If any fields are related, only the first related record is used.

In the following examples:
•

Field1 contains white.

•

Field2 contains black.

•

Field3 contains three repetitions with values of red, green, blue.

•

Related::Field4 refers to three records that contain 100, 200, 300.

When referencing multiple repeating fields, List() returns the list of the values 

across the first repetition in the calculation's first repetition, then the list of the values 
across the second repetition in the second repetition, and so on.