null

Adding the Total to a Column in Report Writer

A common task is adding up the contents of a column to determine the total registration cost, total payments and adjustments, total amount of discount, etc. To add the total to the bottom of any report column, follow these steps:

 

  1. At the far top right of the report, click the Fields tab. Field information for the report will be displayed.
  2. In the panel on the right, select the field to work with. In this example, we will add the total amount to the Registrant Cost column to see the total dollar amount of registrant fees that will be collected for the event.

Selecting Settings for the Registrant Cost field

  1. Click the Settings icon (the gear) at the right. The Field Properties dialog box will be displayed.
  2. Select Total.
  3. Click OK to dismiss the dialog box.

Adding the total to the Registration Cost column

  1. Click Update Results. The report will be displayed and the total amount of the Registration Cost column will be at the bottom of the column.

When the Total property is added to a field, the sum of the displayed data is placed at the end of the column. In this example, we’ve added the Total property to the Registration Cost field as well as the Payments and Adjustments field.

 

Totals for Registration Cost and Payments And Adjustments column are displayed

 

NOTE: The total is the sum of all displayed data. So, if you show a subset of the data using a filter, the total at the bottom of the column is the total for the displayed rows only.

Related Articles

3 Ways to Maintain Quality Relationships With Your Donors
Behind every successful organization is a donor community that is passionate about your cause. A ...
Zoo Management Software: Choosing a Solution + 8 Top Picks
Zoo management systems are an integral part of zoos around the country and world. They serve as ...
Museum Software: FAQ + 12 Top Management Solutions for 2024
The term “museum management software” is often used in the context of museum archive and ...
The New and Improved Doubleknot: 3 Key Features for 2023
It’s no secret that the management of admissions-based organizations like museums, nature centers, ...
Mastercard's 4 New Recurring Payments Rules (and What They ...
In an ongoing initiative to drive continuity and transparency amongst merchants, customers, and the ...
5 Ticketing & Registration Tips for Experiential ...
Take a second to think about the first moment that your patrons’ “experience” with your business ...
Running Your Children's Museum: How Software Can Help
Picture this: It’s a sunny autumn morning, you’ve just opened your museum’s doors, and it’s only a ...
Building an Inclusive Museum Community: A Complete Guide
For as long as museums have existed, they’ve been essential to their communities. They do more than ...
6 Ticketing Software Features to Enhance Your Museum
What does a successful day at your museum look like? Perhaps it involves a number of group tours, ...
Planning Safe Programming for Your Community This Summer
Community programming will look different this summer, but that doesn’t mean it shouldn’t happen at ...