COMPACTFORMAT: Displaying Numbers in an Abbreviated Format

How to:

Display Numbers in an Abbreviated Format

COMPACTFORMAT displays numbers in a compact format where:

K is an abbreviation for thousands.
M is an abbreviation for millions.
B is an abbreviation for billions.
T is an abbreviation for trillions.

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.

Syntax: How to Display Numbers in an Abbreviated Format

COMPACTFORMAT(input)

where:

input: Is the name of a numeric field.

Example: Displaying Numbers in an Abbreviated Format

COMPACTFORMAT abbreviates the display of COGS_US.

COMPACTFORMAT(COGS_US)

For $2,950,358.00, the result is $3M.

	WebFOCUS