MK Conversion

The MK code allows you to display large numbers in a minimum of columns by automatically descaling the numbers and appending a letter to represent the power of 10 used. The letters and their meanings are:

K 10 /3 (Kilo)
M 10 /6(Mega)
G 10 /9 (Giga)

SYNTAX

MKn

SYNTAX ELEMENTS

n is a number that represents the field width. This will include the letter and a minus sign, if present.

NOTES

If a number will fit into the specified field width, it will not be changed.

If the number is too long but includes a decimal fraction, the MK code first attempts to round the fractional part so that the number will fit the field. If the number is still too long, the code rounds off the three low-order integer digits, replacing them with a K. If the number is still too long, the code rounds off the next three digits, replacing them with an M. If that is still too long, the code rounds off three more digits, replacing them with a G. If the number still does not fit the specified field, the code displays an asterisk.

If the field size is not specified or is zero, the code outputs null.

INPUT CONVERSION

Input conversion does not invert. It simply applies the metric processing to the input data.

EXAMPLES

jQL