Working in the Environment › Display Column Totals

Display Column Totals

You can display numeric totals and subtotals for any tabular panel. Column totals are the sum of all lines in the table, not just the lines displayed on the screen. Column subtotals are displayed when a panel is filtered. Column totals are fixed and remain on the screen when you scroll through the data.

You can display column totals by default.

Note: For more information, see the Installation Guide.

Follow these steps:

1. Type TOTals on the COMMAND line.

   The numeric totals for the panel will appear at the bottom of the panel.

   CA MAT  -------------------------- TaskView ---------- Screen CUSTOMIZ changed
   COMMAND ===>                                                SCROLL ===> CSR 
                                                                              
   Primary commands: SELect, RECall, ADDHelp                    Profile: TUNSAMP   
                                                                Options: NORMAL  
      Line commands: T - Tag    C - Code Details                            
                     U - Untag  D - Delay Details                            
                                                                              
   LC Program  T Actv% Data% System% VolWait% InvWait% Other% Total%      
       ________ _ >.03_ _____ _______ ________ ________ ______ ______     
   -----------------------------------------------------------------------
   __ DFHD2EX3    8.31 44.21    0.00     0.06     0.00   0.00  52.58        
   __ DFHD2EX3    0.82 13.22    0.00     0.01     0.00   0.00  14.06      
   __ DFHD2EX3    0.66  8.80    0.00     0.06     0.22   0.00   9.74     
   __ DFHKETCB    0.32  4.06    0.00     4.78     0.00   0.00   9.16        
   __ DFHD2EX3    0.19  3.00    0.00     0.20     0.00   0.00   3.38        
   __ DFHD2EX3    0.69  2.29    0.00     0.01     0.00   0.00   3.00        
   __ DFHD2EX3    0.13  2.64    0.00     0.04     0.00   0.00   2.81        
   __ DFHD2EX3    0.09  0.68    0.00     0.01     0.00   0.00   0.78        
   __ DFHD2EX3    0.04  0.39    0.00     0.12     0.14   0.00   0.69        
   __ DFHD2EX3    0.43  0.22    0.00     0.03     0.00   0.00   0.68        
   ---------------------------- Subtotals and Totals ----------------------
                 11.72 79.95    0.00     5.33     0.36   0.00  97.36        
                 11.88 82.24    0.00     5.49     0.39   0.00 100.00       
   

   If you specify a filter for a field, the subtotals, which are the totals for the filtered data only, are displayed above the totals for all of the data.

   CA MAT   -------------------------- TaskView ---------- Screen CUSTOMIZ changed
   COMMAND ===>                                                SCROLL ===> CSR
                                                                              
   Primary commands: SELect, RECall, ADDHelp                    Profile: TUNSAMP   
                                                                Options: NORMAL  
      Line commands: T - Tag    C - Code Details                            
                     U - Untag  D - Delay Details                            
                                                                              
   LC Program  T Actv% Data% System% VolWait% InvWait% Other% Total%      
       ________ _ >.03_ _____ _______ ________ ________ ______ ______     
   -------------------------------------------------------------------------------
   __ DFHD2EX3    8.31 44.21    0.00     0.06     0.00   0.00  52.58        
   __ DFHD2EX3    0.82 13.22    0.00     0.01     0.00   0.00  14.06       
   __ DFHD2EX3    0.66  8.80    0.00     0.06     0.22   0.00   9.74        
   __ DFHKETCB    0.32  4.06    0.00     4.78     0.00   0.00   9.16        
   __ DFHD2EX3    0.19  3.00    0.00     0.20     0.00   0.00   3.38        
   __ DFHD2EX3    0.69  2.29    0.00     0.01     0.00   0.00   3.00       
   __ DFHD2EX3    0.13  2.64    0.00     0.04     0.00   0.00   2.81        
   __ DFHD2EX3    0.09  0.68    0.00     0.01     0.00   0.00   0.78        
   __ DFHD2EX3    0.04  0.39    0.00     0.12     0.14   0.00   0.69        
   __ DFHD2EX3    0.43  0.22    0.00     0.03     0.00   0.00   0.68        
   ---------------------------- Subtotals and Totals -----------------------
                 11.72 79.95    0.00     5.33     0.36   0.00  97.36         
                                11.88 82.24    0.00     5.49     0.39   0.00 00.00      
   

2. Type TOTals again to remove the totals from the display.

Wildcard Characters

Certain fields accept wildcard characters. Valid wildcard characters are asterisk (*), percent sign (%), and question mark (?).

Asterisk: Use an asterisk at the beginning, middle, or end of a string to indicate the minimum acceptable value.

Asterisk as Wildcard Examples:

• ABC* matches anything that starts with the characters ABC, regardless of what the string ends with.
• *XYZ matches anything that ends with the characters XYZ, regardless of what the string begins with.
• ABC*XYZ matches anything that begins with ABC and ends with XYZ, regardless of how many characters are in between.

Percent Sign: Use a percent sign to indicate that the position must be occupied by a number.

Percent Sign as Wildcard Example:

XYZ%% matches all instances of XYZ followed by two numbers. XYZ30 and XYZ42 satisfy the condition, but XYZ173 and XYZ2A do not.

Question Mark: Use a question mark to indicate that a given position must be occupied by any nonblank character, regardless of its type.

Question Mark as Wildcard Example:

JOB?A% matches all jobs that have JOB in the first three positions, any character in the fourth, an A in the fifth, and a number in the last position. JOB1A6 and JOB#A7 are matches, but JOB1Z is not.