JMP displays numbers as currency using the Format() function, which uses the following syntax:
Format(x,"Currency", <"currency code">, <decimal>);
|
•
|
x is a column or a number
|
|
•
|
"currency code" is an International Standards Organization (ISO) 4217 code
|
|
•
|
decimal is the number of decimal places
|
To illustrate the Format function:
Format( 12345.6, "Currency", "GBP", 3 );
"£12,345.600"
Format( 12345.6, "Currency", 3);
"¥12,345.600"
Format( 12345.6, "Currency", "BBD", 3 );
"BBD 12,345.600"
Currencies Supported in JMP lists the currencies supported in JMP.