Functions Reference

FILEMAKER FUNCTIONS REFERENCE 23
• 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.
StDev
Purpose
Returns the standard deviation of the sample represented by a series of non-blank values in field.
Format
StDev(field{;field...})
Parameters
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
Originated in
FileMaker Pro 6.0 or earlier
Description
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 1::field A, table
2::field B,...)
. You can name a different table for each field (table 1::field
A;table 2::field B...)
.
StDev
x
1
2
x
2
2
… x
n
2
+++
n1–
--------------------------------------------
x
1
x
2
… x
n
+++()
2
nn 1–()
---------------------------------------------------
–=