Minfield - 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.FileMaker Pro 6.0 or earlierField 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.
•
• 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...).Min(Bids::Price) returns the lowest bid submitted for a contract.Min(Field2) returns 5 when the calculation isn’t a repeating field.
• 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.
• Aggregate functions such as Min or Max use the data type of the first parameter to perform all comparisons. For example, if the first parameter’s data type is text, all other parameters are converted to text and then compared.