Displaying Totals for Numeric Columns - SQL Assistant

Displaying Totals for Numeric Columns

1 In the Answerset window, place your cursor into any cell in any column.

2 Do one of the following:

Right-click to display the Shortcut menu and click Add Totals.

Click on the Answerset toolbar.

The totals display for all numeric columns.

The totals remain after the Answerset has been sorted. Totals do not appear in future Answerset windows unless Add Totals is activated again.

Note: The SUM function uses Floating Point values, so totals are only accurate to 15 total digits.

To format columns to display commas, see “Displaying Commas to Mark Thousand Separators” on page 128. To format columns to display decimal places, see “Displaying Decimal Places” on page 128.