Functions Reference

Table Of Contents
Chapter 2
|
Aggregate functions 19
Note 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, (1+5+6)/3=4;(2+6)/2=4;7/1=7;8/1=8.
Count
Format
Count(field{;field...})
Parameter
field - any related field, repeating field, or set of non-repeating fields; or an expression
that returns a field, repeating field, or set of non-repeating fields.
Parameters in curly braces { } are optional.
Data type returned
number
Description
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 related records specified by (table::field), whether or not
these records appear in a portal.
several non-repeating fields in a record (field1;field2;field3...).
corresponding repetitions of repeating fields in a record
(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
tables
(table 1::field A;table 2::field B...).
Examples
The Accounts layout
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 4 when the calculation isn’t a repeating field.