While working with tables, you may wish to get some summary for a particular column. BaccS allows to get the following types of summaries: sum, average, count, max and min. You may add multiple summaries for a single column. Also, you can create summaries for groups in tables
Adding a summary to a column
Summary panel is displayed at the bottom of each table. If this panel is hidden, you can display it by right clicking on a table header and selecting Show summary panel option:
In the same manner, you can hide summary panel when it is not needed.
To add a summary to any column, right click on a summary panel below that column and select desired function:
To add another summary, right click on a summary panel, select Add new summary, and select desired summary type:
Adding a summary to a group
In addition to total summaries, you may create summaries by groups. To get additional information about grouping rows, please check corresponding article
When a table is in grouped state, right click on a corresponding column in the group panel and select Group summary editor:
On the Items tab of the group summary editor, select necessary columns and summary functions for them. You may create as many summaries in this window as needed:
Switch to the Order tab and set desired order of summaries:
Few lists, like jobs list and invoices list, contain special summaries (not customizable). These summaries are located below a table and allow to view totals by currently selected rows. Select necessary rows (using checkboxes or Shift and Ctrl keys), and summary value will be immediately refreshed:
This summary shows not only total amount of selected jobs, but total amount in a base currency and in all currencies of the selected jobs. The same summaries you can find for invoices, payments, translation assignments.