In this section: |
Starting in FOCUS 7.6.4, you can specify which currency symbol will be displayed when a format specification uses the M and N edit options.
How to: |
SET CURRSYMB determines which currency symbol will be displayed when a format specification uses the M and N edit options.
SET CURRSYMB = symbol
In a request, use
ON TABLE SET CURRSYMB symbol
where:
Is any printable character or a supported currency code. Note: In order to specify a dollar sign as the character, you must enclose it in single quotation marks ('$'). The following are supported currency codes:
USD or '$' specifies U. S. dollars.
GBP specifies the British pound.
JPY specifies the Japanese yen.
EUR specifies the Euro.
The following request uses the EMPLOYEE data source and sets the currency symbol to the Japanese yen. Since the EMPLOYEE Master File specifies the format D12.2M for the CURR_SAL field, the yen symbol displays as the currency symbol for its field values:
TABLE FILE EMPLOYEE PRINT CURR_SAL BY LAST_NAME ON TABLE SET CURRSYMB JPY ON TABLE COLUMN-TOTAL END
The output is:
LAST_NAME CURR_SAL --------- -------- BANNING ¥29,700.00 BLACKWOOD ¥21,780.00 CROSS ¥27,062.00 GREENSPAN ¥9,000.00 IRVING ¥26,862.00 JONES ¥18,480.00 MCCOY ¥18,480.00 MCKNIGHT ¥16,100.00 ROMANS ¥21,120.00 SMITH ¥13,200.00 ¥9,500.00 STEVENS ¥11,000.00 TOTAL ¥222,284.00
Information Builders |