Ohio Educational Computer Network System (OECN)
UDMS Beginning Training Guide
Previous Contents

All of the operators are standard except for the "|" (concatenate) which is only applicable for AN type fields. The "|" enables fields/variables/functions/ and/or conatants to be concatenated.

In this exercise, you will calculate a 7% raise for employees in Dept. 10 and a 6% raise for everyone else. The operator is multiplication (*).

Press [Return] to accept the "*" operator.

This brings up the "constant/Expr" field. You can either enter a value here, or leave the field blank and press the Return key to move to the "Field2" field. This is used if you want to multiply (calculate) Field1 by Field2.

For this lesson, enter the value .07 in order to multiply CUR_SALARY by 7%. The resulting screen is shown next. 


 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT2            REPORT DEFINITION MODIFICATION     View: PRSPAY               |                                             
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..|                                             
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY                          |                                             
|**********  ***************  *******  **********  ***********                          |                                             
|                                                                                       |                                             
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99                          |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
| Calc Fields: 0           CALCULATED FIELD DEFINITION       Columns Avail: 26          |                                             
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       |                                             
|                                                                                       |                                             
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       ___       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
| DEFINE                                 <PF2> help    <PF3> cancel  <PF4> finished     |                                                
|                                                                                       | 
|_______________________________________________________________________________________|                                                                                                                                    g

Press the [Return] key to accept the .07 value. The cursor will now prompt for a condition. Since in this example you want a 7% raise to be awarded to only those employees in Dept. 10, you will place the "WHN" (WHEN) condition in this field. Press the [PF2] (HELP) key to see the possible selections. The following is a typical screen. 


 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT2            REPORT DEFINITION MODIFICATION     View: PRSPAY               |                                             
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..|                                             
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY                          |                                             
|**********  ***************  *******  **********  ***********                          |                                             
|                                                                                       |                                             
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99                          |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
| Calc Fields: 0           CALCULATED FIELD DEFINITION       Columns Avail: 26          |                                             
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       |                                             
|                                                                                       |                                             
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       ___       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
| DEFINE               <PF1> select   <PF2> help    <PF3> cancel  <PF4> finished        |                                             
|                                                                                       |                                             
| If this calculation is to be made only if some condition  |  WHN                      |                                             
| is true, enter 'WHN' here and specify the condition(s)    |                           |                                             
| in subsequent entries.  If this calculation is to be      |                           |                                             
| 'unconditionally' performed, leave this detail blank.     |                           |                                             
|_______________________________________________________________________________________|                                                                                                                                    g

Enter the condition WHN, and press the [Return] key. The following screen will appear. 


 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT2            REPORT DEFINITION MODIFICATION     View: PRSPAY               |                                             
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..|                                             
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE               |                                             
|**********  ***************  *******  **********  ***********  *********               |                                             
|                                                                                       |                                             
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99               |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
| Calc Fields: 1           CALCULATED FIELD DEFINITION       Columns Avail: 15          |                                             
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       |                                             
|                                                                                       |                                             
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       WHN       |                                             
|   2                             __________...                                         |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
| DEFINE                <PF1> select   <PF2> help                  <PF4> finished       |                                              
|                                                                                       |                                             
|_______________________________________________________________________________________|                                                                                                                                    g

The newly calculated field, CA_RAISE is automatically added to the default column detail display, as shown in the screen above. (Note this field and the ruler in the top window.) The column header is displayed with the name underlined with *'s. The mask just defined becomes the default mask for this field and is displayed in the top window.

This new field, CA_RAISE, is now available for all other sections of the report (other calculations, qualifications, format sections. etc.)

Since you have specified that CA_RAISE is to be conditional, you are now prompted for the qualifiication, beginning with Field1. Again, you only want to calculate the 7% raise when the DEPTNO is equal to 10. Enter this data as shown in the next screen. 


_________________________________________________________________________________________ 
|                                                                                       | 
| Calc Fields: 1           CALCULATED FIELD DEFINITION       Columns Avail: 15          |                                             
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       |                                             
|                                                                                       |                                             
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       WHN       |                                             
|   2                             DEPTNO         EQ 10                 ====>  ELS       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
|                                                                                       |                                             
| DEFINE                              <PF2> help    <PF3> cancel  <PF4> finished        | 
|                                                                                       | 
|_______________________________________________________________________________________|                                                                                                                                    g

Notice the "ELS" (ELSE) condition which appears as a default in the Cond field. This condition indicates that you need to specify what is to happen if the condition, "DEPTNO EQ 10" is not true. Press the [Return] key to accept the ELS condition.

Since you want CA_RAISE to reflect a 6% increase in this case, enter the data as shown in the next screen. 


_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT2            REPORT DEFINITION MODIFICATION     View: PRSPAY               |                                             
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..|                                             
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE               |                                             
|**********  ***************  *******  **********  ***********  *********               |                                             
|                                                                                       |                                             
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99               |                                             
|                                                                                       |                                            
|                                                                                       |                                             
|                                                                                       |                                             
| Calc Fields: 1           CALCULATED FIELD DEFINITION       Columns Avail: 15          |                                             
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       |                                             
|                                                                                       |                                             
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       WHN       |                                             
|   2                             DEPTNO         EQ 10                        ELS       |                                             
|   3                             CUR_SALARY     *  .06  <====                          |                                                  
|                                                                                       |                                             
|                                                                                       |                                             
| DEFINE                               <PF2> help    <PF3> cancel                       |                                              
|                                                                                       |                                             
|_______________________________________________________________________________________|                                                                                                                                    g

Press the [Return] key to accept the above data. A screen similar to the following will appear. 


 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT2            REPORT DEFINITION MODIFICATION     View: PRSPAY               |                                             
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..|                                             
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE               |                                             
|**********  ***************  *******  **********  ***********  *********               |                                             
|                                                                                       |                                             
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99               |                                             
|                                                                                       |                                            
|                                                                                       |                                             
|                                                                                       |                                             
| Calc Fields: 1           CALCULATED FIELD DEFINITION       Columns Avail: 15          |                                             
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       |                                             
|                                                                                       |                                             
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       WHN       |                                             
|   2                             DEPTNO         EQ 10                        ELS       |                                             
|   3                             CUR_SALARY     *  .06                                 |                                             
|   4 ___________...                                                                    |                                             
|                                                                                       |                                             
| DEFINE                              <PF2> help                  <PF4> finished        |                                            
|                                                                                       |                                             
|_______________________________________________________________________________________|                                                                                                                                    g

Define Another CALCULATED Field

So far you have created a calculated variable for the different raises, now you will create another calculated field (variable) to show the adjusted salaries. This calculated field, CA_NEW_SALARY, will be nonconditional. The format is given next. 


 
         CA_NEW_SALARY EQ CUR_SALARY + CA_RAISE

Enter the field name, CA_NEW_SALARY, on line #4 and press the [Return] key to advance to the "Typ" field as shown next. 


 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT2            REPORT DEFINITION MODIFICATION     View: PRSPAY               |      
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..|  
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE               |    
|**********  ***************  *******  **********  ***********  *********               |   
|                                                                                       | 
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99               |   
|                                                                                       |  
|                                                                                       |   
|                                                                                       |  
| Calc Fields: 1           CALCULATED FIELD DEFINITION       Columns Avail: 15          |  
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       |  
|                                                                                       |  
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       WHN       |   
|   2                             DEPTNO         EQ 10                        ELS       |   
|   3                             CUR_SALARY     *  .06                                 |     
|   4 CA_NEW_SALARY  NU  <=====                                                         |  
|                                                                                       | 
|                                                                                       |   
| DEFINE                                 <PF2> help                  <PF4> finished     |    
|_______________________________________________________________________________________|

Press the [Return] key to advance to the Mask field and enter the value, $999,999.99 for the mask. You will note the pop-out window will appear because of the size of the value. Press the [Return] key again to accept this value and advance to the next field.

A screen similar to the following should appear. 


 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT2            REPORT DEFINITION MODIFICATION     View: PRSPAY               |  
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..|  
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE               |  
|**********  ***************  *******  **********  ***********  *********               | 
|                                                                                       |    
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99               |   
|                                                                                       |   
|                                                                                       |   
|                                                                                       |    
| Calc Fields: 1           CALCULATED FIELD DEFINITION       Columns Avail: 15          | 
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       | 
|                                                                                       |  
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       WHN       |  
|   2                             DEPTNO         EQ 10                        ELS       |  
|   3                             CUR_SALARY     *  .06                                 |        
|   4 CA_NEW_SALARY  NU $999,...  _____________                                         |                                        
|                                                                                       | 
|                                                                                       |    
| DEFINE                                 <PF2> help                  <PF4> finished     | 
|_______________________________________________________________________________________|

Enter the field name, CUR_SALARY, then press [Return], and advance to the Opr. field. Enter the value "+" and press [Return]. This will advance you to the "Constant/Expr" field. Since the next entry is to be in the "Field2" column, press [Return] to advance to "Field2" and enter the value, CA_RAISE.

The following screen shows how the data should look. 


 
 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT2            REPORT DEFINITION MODIFICATION     View: PRSPAY               |  
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..|  
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE               |    
|**********  ***************  *******  **********  ***********  *********               |  
|                                                                                       |  
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99               |  
|                                                                                       |   
|                                                                                       | 
|                                                                                       | 
| Calc Fields: 1           CALCULATED FIELD DEFINITION       Columns Avail: 15          |   
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       |     
|                                                                                       | 
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       WHN       |   
|   2                             DEPTNO         EQ 10                        ELS       |     
|   3                             CUR_SALARY     *  .06                                 | 
|   4 CA_NEW_SALARY  NU $999,...  CUR_SALARY     +                CA_RAISE    ___       | 
|                                                                                       | 
|                                                                                       |  
| DEFINE                                 <PF2> help                  <PF4> finished     | 
|_______________________________________________________________________________________|

Press the [Return] key to advance to the "Condition" field. Since this calculated field is to be unconditional, press the [Return] key again to accept the calculated field as defined. A screen similar to the following should appear. 


 
_________________________________________________________________________________________ 
|                                                                                       |    
| Rpw: REPORT2            REPORT DEFINITION MODIFICATION     View: PRSPAY               |     
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..|    
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE  CA_NEW_SALARY|     
|**********  ***************  *******  **********  ***********  *********  *************|      
|                                                                                       |     
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99    $999,999.99|    
|                                                                                       |   
|                                                                                       | 
|                                                                                       |    
| Calc Fields: 2           CALCULATED FIELD DEFINITION       Columns Avail: 0           |   
|   Calc Field Name Typ Mask      Field1        Opr Constant/Expr Field2     Cond       | 
|                                                                                       |      
|   1 CA_RAISE       NU $9,99...  CUR_SALARY     *  .07                       WHN       |    
|   2                             DEPTNO         EQ 10                        ELS       |    
|   3                             CUR_SALARY     *  .06                                 |  
|   4 CA_NEW_SALARY  NU $999,...  CUR_SALARY     +                CA_RAISE              |   
|   5 ___________...                                                                    | 
|                                                                                       | 
| DEFINE                                 <PF2> help                  <PF4> finished     | 
|_______________________________________________________________________________________|

Previous Next Contents