Totals

Introduction

A total is an expression, which can be a variable, that is typically placed in the report's footer section.

Tip: You can use Active Complete to automatically add totals to the report when you add a variable or expression.

Include a grand total at the end of a report.
Add a cumulative total to each page of a report.
Provide a total for each set of grouped information.
On each line of your report to show a running total.
Draw attention to the total using colour or a warning mesHerb when a condition is met. See Conditional formatting.
Change the appearance of the total, such as the number of decimal places used. See Appearance properties.
Link the total to additional information. See Drill down reports.

To add a total:

Select Add Expression from the toolbar, or choose Toolbox > Add Expression.
Click in the section you want to display a total.

The Expression Editor opens. See Expressions.
Drag the variable you want to use for the total from the Fields pane into the left-hand pane, then click OK.
In the Properties pane, check Function is set to Sum.
To label the total, add a text box.

Select Add Text from the toolbar, or choose Toolbox > Add Text. See Text, lines and boxes.

Tip: Instead of using the Expression Editor, alternatively you can drag and drop the variable you want to use for the total from the Variables pane.