Apple M9057 User Manual - Page 193
Defining calculation and summary fields, Qty Sold and Price, and one calculation field
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 193 highlights
Database 8-11 For complete information on every field type available in AppleWorks, see onscreen Help. Defining calculation and summary fields In the Help index,* see: E formulas, database 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. Name of field that holds the formula Choose a format for the formula result Click field names, operators, and functions to include in the formula * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.