Filemaker Pro 9 (46)

Question 1

This deck created on 4-24-2014

1. OTHER SUMMARY FIELD TYPES (cont’d): FRACTION OF TOTAL. What is this option?

Answer 1

It looks at the total for the GROUP you’re summarizing, AS WELL AS the total for the entire database. It then reports WHAT PORTION OF THE OVERALL TOTAL THE GROUP REPRESENTS, as a decimal number.

Question 2

2. When you choose FRACTION OF TOTAL, you get a SUBTOTALED checkbox. What is it?

Answer 2

When you turn SUBTOTALED on, you get to pick another field from a list called WHEN SORTED BY. This tells you that you must SORT the record by the selected field for this SUMMARY FIELD to work. If you don’t sort the records yourself before you view the report, the field stays empty.

Question 3

3. FM looks at the selected field in SUBTOTALED: WHEN SORTED BY, and figures out which records have:

Answer 3

the SAME value in them as in the current record, and calculates the fraction based only on the total of THOSE records.

Question 4

4. On what page is FRACTION OF TOTAL?

Answer 4

p. 296