How to: |
COMPACTFORMAT displays numbers in a compact format where:
COMPACTFORMAT computes which abbreviation to use, based on the order of magnitude of the largest value in the column. The returned value is an alphanumeric string. Attempting to output this value to a numeric format will result in a format error, and the value zero (0) will be displayed.
COMPACTFORMAT(input)
where:
Is the name of a numeric field.
The following example uses the COMPACTFORMAT function to abbreviate the display of the summed values of the DAYSDELAYED, QUANTITY_SOLD, and COGS_US fields.
TABLE FILE WFLITE SUM DAYSDELAYED QUANTITY_SOLD COGS_US COMPUTE CDAYS/A30= COMPACTFORMAT(DAYSDELAYED); CQUANT/A30= COMPACTFORMAT(QUANTITY_SOLD); CCOGS/A30= COMPACTFORMAT(COGS_US); ON TABLE SET PAGE NOPAGE ON TABLE SET STYLE * GRID=OFF,$ ENDSTYLE END
The output is shown in the following image.