Defining calculation and summary fields – Apple AppleWorks 5 : Mac OS User Manual
Page 193

Database
8-11
For complete information on every field type available in AppleWorks, see
onscreen Help.
Defining calculation and summary fields
You define a field type as a calculation or summary field when you want the
value in the field to be the result of a formula. A formula can include values
from one or more other fields in the database, operators, functions, and
constant values.
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.
*
Choose Index from the
or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index,
*
see:
E
formulas, database
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
- Numbers '09 (254 pages)
- Keynote '09 (247 pages)
- Pages '09 (279 pages)
- Boot Camp Mac OS X v10.6 Snow Leopard (18 pages)
- Boot Camp Mac OS X v10.6 Snow Leopard (19 pages)
- iWork '09 (372 pages)
- Mac OS X v10.6 Snow Leopard (7 pages)
- GarageBand '08 (102 pages)
- iDVD '08 (35 pages)
- GarageBand '09 (122 pages)
- iWeb (37 pages)
- iMovie '08 (50 pages)
- Boot Camp (Mac OS X v10.5 Leopard) (27 pages)
- Boot Camp (Mac OS X v10.5 Leopard) (25 pages)
- Mac OS X v10.5 Leopard (16 pages)
- Mac OS X (622 pages)
- Mac OS X Server (Version 10.6 Snow Leopard) (197 pages)
- Mac OS (42 pages)
- Mac OS X Server (Upgrading and Migrating For Version 10.4 or Later) (97 pages)
- iMovie HD (83 pages)
- iMovie HD (47 pages)
- MAC OS 7.6.1 (4 pages)
- Mac OS X Server (Extending Your Wiki Server For Version 10.5 Leopard) (45 pages)
- Mac OS X Server Ver 10.4 (35 pages)
- Mac OS X Server v10.6 (76 pages)
- Mac OS X Server v10.6 (97 pages)
- Macintosh Japanese Language Kit (30 pages)
- Xserve (Early 2008) DIY Procedure for Hard Drive (3 pages)
- Xserve (8 pages)
- Xserve (60 pages)
- GarageBand 3 (98 pages)
- Remote Desktop 3.1 (191 pages)
- Motion 5.1.1 (1090 pages)
- Workgroup Server 8150/110 (144 pages)
- Aperture (476 pages)
- Xserve Intel (Late 2006) DIY Procedure for Optical Drive Cable (7 pages)
- Xserve Intel (Late 2006) DIY Procedure for Optical Drive Cable (6 pages)
- Network Services Location Manager Network (8 pages)
- Macintosh System 7.5 (65 pages)
- Macintosh System 7.5 (126 pages)
- Macintosh System 7.5 (114 pages)
- DVD Studio Pro 4 (656 pages)
- Keynote '08 (204 pages)
- Xsan 2 (Second Edition) (11 pages)
- LiveType 2 (157 pages)