How to output a numeric field into UK / USA numeric format (Method 2) …

TIP: Use this tutorial if the spool output is in the form ######.#

  1. Open the process.
  2. Add the variable version of the numeric field you wish to format.
  3. Right-click on the variable and select Edit Script…
  4. Insert the following code:

$variablename=nformat(“Z,ZZZ,ZZZ,ZZ#.##”,$variablename);

  1. Click OK.

Export, deploy and test!

The unformatted numeric field will now output in the US / UK format.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s