Filemaker Pro 8.5 Educational Maintenance T2 TJ085LL/A Manuel D’Utilisation
Codes de produits
TJ085LL/A
Chapter 2
|
Aggregate functions 23
Parameters in curly braces { } are optional.
Data type returned
text, number, date, time, timestamp
Description
Returns the smallest valid non-blank value in:
•
•
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
(field1;field2;field3...).
•
corresponding repetitions of repeating fields in a record
(repeatingField1;repeatingField2;repeatingField3), if the result is
(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::field1;table::field2;...). You can include fields from different
(table 1::field A;table 2::field B...).
Examples
A Contracts table has a portal showing bids submitted for each contract.
Min(Bids::Price) returns the lowest bid submitted for a contract.
In the following examples:
•
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.
Min(Field2) returns
5
when the calculation isn’t a repeating field.
Min(Field1;Field2;Field3) returns
1
,
2
,
7
,
8
when the calculation is a repeating
field.
Note
When a referenced field is a repeating field, the Min function returns the minimum
value in the first repetition field, then the minimum value in the second repetition field, and
so on.
so on.
StDev
Format
StDev(field{;field...})