Help

FILEMAKER PRO HELP 665
Count(Field2) returns 4 when the calculation isn’t a repeating field.
Count(Field1;Field2;Field3) returns 3, 2, 1, 1 when the calculation is a repeating field.
Note 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.
Related topics
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
List
Purpose
Returns a concatenated list of non-blank values (separated by carriage returns) for a field or fields.
Format
List(field{;field...})
Parameters
field - any related field, repeating field, or set of non-repeating fields; an expression that returns a
field, repeating field, or set of non-repeating fields, or a variable.
Parameters in curly braces { } are optional.
Data type returned
text
Originated in
FileMaker Pro 8.5
Description
Use this function to return a list of values for:
• a single field (table::field), which returns 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...),
which returns 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.