Filemaker Pro 9 (117)

Question 1

This set entered on 8-3-14
8.2.14.6

1. Many times you need to know either the highest or the lowest value in a series. How do you find out?

Answer 1

Use the MAX or MIN Functions. They are found in the Function List, under AGGREGATE FUNCTIONS.

Question 2

2. Like all AGGREGATE FUNCTIONS, the Min and Max expect at least one parameter, and each parameter should be:

Answer 2

a number.

Question 3

3. Parameters for the Min or Max functions can be:

Answer 3

a. Constant data
b. Fields with a record
c. Repeating fields
d. Related fields

Question 4

4. What does the Max Function do?

Answer 4

It looks at every number referenced and returns whichever is greatest. Min returns the smallest value.

Question 5

5. What would this calc return: Max ( 10 ; 3 ; 72 ; 19 ; 4 )?

Answer 5

72

Question 6

6. What would this calc find: Max ( Line Items::Price )?

Answer 6

The most expensive item.

Question 7

7. With both Repeating Fields and Related Fields, you pass JUST ONE FIELD to the Min or Max function, but FileMaker considers:

Answer 7

ALL the values in that field. If it’s a REPEATING FIELD, FileMaker considers every repetition. If it’s a RELATED FIELD, its value from every related record is considered.