Group And Report Level Totals/Calculations

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

When it comes to doing calculations at different levels there are two main things to keep in mind.

 

1. If the calculation is being done at the group or report level, the Summary needs to be set accordingly.

mceclip0.png

 

2. Calculations at the Group/Report level need to use sumSum() functions.

mceclip1.png

 

 

Group Level Calculations

1. Add a label to the Group Footer.

mceclip5.png

 

2. Click the menu button on the label.

mceclip4.png

 

3. Set the Summary option to Group.

mceclip6.png

 

4. Edit the Expression. Use the same logic for any other Expression keeping in mind that each field needs to be within a sumSum(), sumCount(), etc.

mceclip7.png

 

 

Report Level Calculations

1. Add a label to the Report Footer. (Insert Report Footer by right clicking in the body of the report and selecting Insert Band > Reportfooter)

mceclip5.png

 

2. Click the menu button on the label.

mceclip4.png

 

3. Set the Summary option to Report.

mceclip6.png

 

4. Edit the Expression. Use the same logic for any other Expression keeping in mind that each field needs to be within a sumSum(), sumCount(), etc.

mceclip7.png

 

Example Output including Detail level calculations, group and report level calculations.

mceclip8.png

Have more questions? Submit a request

Comments