Apple AppleWorks 5 : Windows 95/NT 4.0 - Manual (Page 179)

Database 8-11
For example, suppose you have a database that contains two number fields,
Qty Sold and Price, and one calculation field, Total. You can set up a formula
in the calculation field to multiply the values in the two number fields. Then,
each time you type values in the Qty Sold and Price fields, the formula
multiplies those values and displays the result in the Total field.
You enter a formula for a calculation or summary field just as you do for a
spreadsheet cell. (See “Working with formulas” on page 7-20.) The type of
operation a formula performs depends on the field type of the values it
calculates and whether the formula’s field type is calculation or summary.
1
Use a calculation field to calculate a value from values in other fields in
the current record.
1
Use a summary field to calculate a summary value using values from one
or more records in the database.
You immediately see the result for a calculation field in Browse mode and
List mode when you add records, and when you change values used in
a calculation.
Note To see the result for a summary field, you must create a summary part
in Layout mode, and insert the summary field. Then, sort the records and
switch to page view. For more information about summarizing data, see
“Presenting and summarizing data with parts” on page 8-34.
Click field names, operators, and functions
to include in the formula Choose a format for
the formula result
Name of field that
holds the formula