Discoverer Plus - Creating Totals

...

Distribution

ODS Specialist

ODS Specialist-Limited

ODS Specialist-Restricted

Ownership

The ISDS System Usability Director is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

Creating Totals

Totals are the result of applying a function, such as the average or sum or count, to all the values in a particular item.

Totals appear

In Table format - below the values in the output item.
In crosstab format - below columns and to the right of rows.

A subtotal is displayed at the end of the group sorted item.

A grand total for each reporting function is displayed at the end of the output.

Sums of rows and columns of numbers, averages of values, standard deviations, subtotals, grand totals, and so on are all standard elements of tables and of crosstabs of numeric data. Whereas, Count and Count Distinct can be used on values that are not numeric – like count the number of names or count the number of Distinct names.

Several predefined totals are available in the Total dialog box. The functions in the table are predefined totals; some of them are also available as toolbar buttons on the Analysis toolbar. For text (indicated by C for character) and date items (indicated by D for date), only the Count, Count Distinct, Minimum, and Maximum functions are available.

*Function*	*Data Type*	*Column Application*
Average	N	Arithmetic average of all values
Count	N, C, D	Number of values
Count Distinct	N, C, D	Number of unique values
Maximum	N, C, D	Maximum value
Minimum	N, C, D	Minimum value
Standard Deviation	N	Arithmetic standard deviation
Sum	N	Total of all values
Variance	N	Arithmetic variance
Percentage of Grand	N	Arithmetic percentage of a value

Discoverer Plus
Menu > Edit> Worksheet > Calculations >My Totals>
New>New Total

To edit an existing total select the one you want to edit and right click then select [Edit].

Alternately, you can click the total (or subtotal row) with the right mouse button; a drop-down list appears displaying two options:

Copy: You can copy selected numbers to another document.
Edit Total: You can edit total or subtotal items. This option brings up the Edit Total window saving the step below.

NOTE: If the data column is not numeric you cannot create a numeric function on it. However, you might be able to find the same element in a numeric format in a different [Available Items] folder.

If you want report to show the word “Sum” and the Project Number being subtotaled, then select Insert Value.

This is how it will look on the report where the project number is 102166 and the sum is 6,464.79:

It is clearer if the currency shows as currency in this case, so edit the column to show currency.

Right click to select the column then select [Format Data].

The result shows this way:

Add the word “Project” in the label field to have the following result on the report:

To calculate a sum such as a grand total and place it at the bottom of the page, select “Grand total at the bottom,” rather than Subtotal.

To copy or edit a total you click the total (or subtotal row) with the right mouse button; a drop-down list appears displaying two options:

Copy: You can copy selected numbers to another document.
Edit Total: You can edit total or subtotal items. This option brings up the familiar Edit Total window.

Effective: 10/25/10

Revision: 1

Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.