Calculate the average, minimum, maximum, or sum values for specified numeric fields (columns) in the current table. Calculations may be performed on dBASE Plus numeric and float fields, or Paradox number, money, or short fields, in the current table. If the current table does not have any numeric or float fields, a message box appears.

The result appears in the Calculation Results dialog box. Choose OK to close the window.

If the Deleted checkbox is not checked in the Desktop Properties dialog box deleted rows are included in the calculations.

Dialog box options

 

Calculation

Choose a calculation to be performed on specified fields:

Average. calculates the average of the specified numeric or float expression and returns a float value.

Minimum. calculates the minimum value of the specified field and returns the same data type as the field specified.

Maximum. calculates the maximum value of the specified field and returns the same data type as the field specified.

Sum. calculates the sum of the specified field and returns a float value.

Available fields

Choose a field of the current table for calculation. Only those numeric fields that can be calculated are shown.

Limit rows

Enter an SQL WHERE statement in the Where box to filter the rows of the current table, that is to create a more limited rowset for this calculation.

How to get there: In Table Run mode, choose Table|Calculate Aggregates.