When you sum the values of a numeric field and the resulting amount is too large to display, FOCUS will display the value as asterisks (*****). This may occur if you are summing data for a large span of time, if you are reporting on systemwide data, or even if you are reporting for a large campus.
In the example below, the designated format for gross pay (PH:GROSSPAY) is P12.2M. Translation: Packed decimal, 12 characters in length, displayed with 2 decimal places and a floating dollar sign. To view the format for a given field, refer to the CIRS Data Element Dictionary.
|
Report Request:
|
Results:
|
|
EX PH
TABLE FILE PH
SUM PH:GROSSPAY
END
|
PH:GROSSPAY
-----------
*********
|
If the field to be increased is part of the verb phrase, you can change the length simply by specifying a new format immediately after the fieldname. In the example below, the length is changed from 12 to 16. Note: To change the length of a sort field, you must use a define. Refer to your FOCUS documentation for more information.
|
Report Request:
|
Results:
|
|
EX PH
TABLE FILE PH
SUM PH:GROSSPAY/p16.2m
END
|
PH:GROSSPAY
-----------
$210,715,126.43
|
Warning! When you create hold files, be sure to verify the results before using the hold file as part of a match request. Otherwise, if your field lengths are not sufficient, the resulting data will be erroneous and FOCUS may NOT display an error message. For example:
|
Report Request:
|
Results:
|
|
EX PH
TABLE FILE PH
SUM PH:GROSSPAY
ON TABLE HOLD AS PERMRPT
END
|
Number of records in table = 79159
HOLDING...
>
|
To quickly verify the data in your hold file, execute a request that uses a wildcard. For example:
|
Report Request:
|
Results:
|
|
TABLE FILE PERMRPT
PRINT *
END
|
PH:GROSSPAY
-----------
********
|
For more information on changing the length of fields, refer to your FOCUS documentation or to the material in the Basic CIRS Workbook.