Displaying Totals for Numeric Columns - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2430
Product Category
Teradata Tools and Utilities
  1. Place your cursor into any cell in any column.
  2. Do one of the following:
    • Click .
    • Right-click in the Answerset window and click Add Totals.

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.

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. To format columns to display decimal places, see Displaying Decimal Places.