DBSum -- Add the value of a field across records |
DBSum(field-name) |
Performing Calculations |
To calculate the total of all of the numeric contents of a specific database field, use the FileFlex DBSum function. Supply the name of a numeric field and put the result into a container. Copy and paste the following line into your script to handle this task, making appropriate changes in the field and container names: |
put DBSum("SALARY") into myPayroll |
DBAverage |
22
|