The command Fields+Total of the table browser window allows the user to get total information by selected field (column) for all records presented in the browser window or only for selected ones.
If the search condition or the indication of removing duplicated records is specified, the total information by field will be formed not by all table records, but only by those records which became parts of the query.
When performing the command Fields+Total the user should choose By All Records or By Selected Records in the nested menu. After that a dialog box “Total by field” is opened (figure 29-1).
Figure 29-1. Dialog box “Total by field”
The contents of the information in this dialog box depends on the field type and it is presented in table 29-1. In the first column of the table all possible operations for calculating the total are enumerated. The remaining columns contain data about admissibility of the present operation depending on the field type (“True” in the table cell means admissibility of the appropriate calculation for the present field type). Description of operations is given in table 29-2.
Field type | |||||
Operation | Integer | Real | String | Date, Time, Timestamp | Boolean |
Number of records | True | True | True | True | True |
Number of not empty values | True | True | True | True | True |
Number of empty values | True | True | True | True | True |
Minimum | True | True | False | True | False |
Maximum | True | True | False | True | False |
Average | True | True | False | False | False |
Sum | True | True | False | False | False |
Number of values “True” | False | False | False | False | True |
Number of values “False” | False | False | False | False | True |
Table 29-1. Total calculations by field
Operation | Description |
Number of records | Total number of records in a query is calculated |
Number of not empty records | Number of records in a query containing not empty value in the field is calculated |
Number of empty records | Number of records in a query containing an empty value in the field is calculated |
Minimum | Minimum field value among query records is evaluated; records with empty field value are not taken into account. |
Maximum | Maximum field value among query records is evaluated; records with empty field value are not taken into account |
Average | Average field value by records in a query is calculated; records with empty field value are not taken into account |
Sum | Sum of field values in query records is calculated; records with empty field value are not taken into account |
Number of values “True” | Number of query records having the “True” field value is calculated; records with empty field value are not taken into account |
Number of values “False” | Number of query records having the “False” field value is calculated; records with empty field value are not taken into account |
Table 29-2. Description of operations for calculating totals
Let's take an example. It is necessary to get an answer to the request “how many inhabitants are there in Sea Lane?” using the table “List of Building Certificates”. To do this it is necessary to perform the following actions:
open the browser window of the table “List of Building Certificates” (chapter 24 “Browsing a table”);
perform the search in accordance with the condition – field value “Street” is equal to “Sea Lane” (chapter 26 “Searching records in a table”);
select the field “Total Inhabitants”, perform the command Fields+Total and select By All Records in the nested menu. The value in the line “Sum” in the opened dialog box “Total by field Total Inhabitants” (figure 29-1) will show total inhabitants in Sea Lane.
 |  |
