Min()

Category: Aggregate

Syntax: Min ( field {; field...} )


Parameters:

fieldAny related field, repeating field, or set of non-repeating fields that represent a set of numbers. Parameters in curly braces { } are optional.

Data type returned: Text, Number, Date, Time, Timestamp

Description:

Returns the lowest valid, non-blank value from the set of values specified by the field parameter.

When the parameter list consists of two or more repeating fields, Min() returns a repeating field in which the corresponding repetitions from the specified fields are evaluated separately. So, if a field Repeater1 has three values, 16, 20, and 24, and another field, Repeater2, has two values, 14 and 25, Min (Repeater1; Repeater2) would return a repeating field with values 14, 20, and 24.

Because dates, times, and timestamps are represented internally as numbers, the Min() function can be used to compare data of these data types. For instance, to return the earlier of two dates, you could use the following type of formula:

 GetAsDate (Min (Date (4; 1; 2005); Get (CurrentDate)))


This example would return either 4/1/2005 or the current date, whichever is less.

Examples:

Function

Results

Min (44; 25; 129)

Returns 25.

Min (repeatingField)

Returns 10 (when repetition 1 = 18, repetition 2 = 10, and repetition 3 = 54).

Min(Invoice:InvoiceAmount)

Returns the lowest invoice amount found in the set of related Invoice records.




: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

show all menu



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352
Similar book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net