When you to want sum value field values in a summary field rather than outputting individual value fields on their own line, you can turn a value field into a summary field.
Do the following:
- Ensure the Sort type of the row containing the value field is set to Combine. This ensures that you will be outputting only summary rows instead of repeating lines with information on individual database objects
- Select the value field to sum and double-click to open the Value Field Properties dialog box.
- You have these choices:
Click Don’t sum values if you do not want any summaries made.
Click Sum values across all rows to sum all of the similar values of all rows.
Click Sum values within one row to add up all of the values of one row. All other rows are ignored.
- Click OK to save the changes.
- Then click OK to close the dialog box.
If you want to print the number of combined output lines, add a value field with the attribute "NUMBER". If you do not want to combine lines but rather output each line and a summary row with an intermediate sum after them, we recommend that you use the Sum value field function to calculate the sum.
