Performing calculations on a selection of rows
You can perform calculations on number fields to obtain useful information from a selection of rows. For example, you might calculate the total sales for a given month, the largest sale, the smallest sale, or the average sale amount.
You can perform the calculations shown here
|
Calculation type |
Result |
|
Average |
Average field value in selected rows |
|
Minimum |
Minimum field value in selected rows |
|
Maximum |
Maximum field value in selected rows |
|
Sum |
Sum total of field values in selected rows |
Most calculations work on numeric and float fields only, but Maximum and Minimum can also be used with date and character fields.
To calculate values,
Select the table, then choose Table|Calculate Aggregates. The Calculate Aggregates dialog box appears.
Choose the type of calculation you want to perform, then select one or more of the listed fields. (Use Shift+click to select several contiguous fields, or Ctrl+click to select several noncontiguous fields.)
Optionally, you can type an expression in the Where box to select a group of rows on which to perform the calculation
Click OK.
dBASE Plus performs the calculation and displays the results in the Calculation Results message box.