Displaying Aggregate Values
Teradata SQL Assistant allows you to quickly calculate aggregate values for selected portions of the Answerset window.
To display aggregate values
1 Highlight the cells you want to aggregate.
2 Release the mouse button. The Sum, Count, Average and Standard Deviation appear on the status bar.
Note: The Aggregate function uses Floating Point values, so totals are only accurate to 15 total digits.
You can select a row, multiple rows, a column, multiple columns, or any block of cells. Nonnumeric cells included within your selection are ignored.