U.M. (Mac OS)

Creating a database file 2-13
5. Click OK twice, and then click Done.
Keep these points in mind:
1 You can set indexing options for a calculated field when you define
the calculation. (See “Writing formulas for calculation fields” on
page 2-20.)
1 To use the index for data entry, see “Working with the index” on page
4-10.
Understanding formulas
You write a formula (a specific operation on one or more values in the
database) for a calculation or summary field. For example, suppose your
file contains two number fields—Unit Price and Quantity—and one
calculation field, Subtotal. You want to calculate a value for Subtotal in
each record, so you write the calculation formula:
Unit Price * Quantity
for the Subtotal field. Then, each time you type values in Unit Price and
Quantity, the formula multiplies those values and displays the result in
Subtotal.
Choose FileMaker Help Index from the or Help menu, and then type:
E index
?
Contains a formula that multiplies the value in
Unit Price by the value in Quantity
Contains a formula that multiplies the value in
Tax Rate by the value in Subtotal and adds
the result to Subtotal