IBM Support

English and French currency formats

Troubleshooting


Problem

Can the language settings for currency be set in Impromptu (on the application level) similar to the Regional Settings in the operating system? Example of different formats: English: $123,456.89 French: 123 456,89$ The language settings could then be applied as English for an English report or French for a French report. These settings would be saved in each individual report.

Resolving The Problem

Impromptu does not have have a "Regional Setting" on the application level.

Note:
Changing the language edition of Impromptu will not apply the proper currency format.

To obtain the proper formats, do the following:

1. Create a calculation in the report or the catalog:
Call = Currency *100
** The multiplication by 100 is important, since Impromptu implicitly places the decimal after the last pound sign, rounding $1.86 (currency format) to 2 $ (custom format).

2. Edit the Format of the results as followings:

Regional Setting Convert to (currency) Format
English (US) French ### ### ###","## $
French (Standard) English $ ###","###","###"."##

** The quotes around the decimal separator are very important.
Without them, Impromptu will use the default separator character set in the system Regional Settings. Using the quotes overrides this tendency.
** There must be enough pound signs to hold the largest number. If there are not, Impromptu reverts to using default separator character set in the system Regional Settings.

[{"Product":{"code":"SSTQPQ","label":"Cognos Series 7"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Impromptu 5.0;Impromptu 7.3","Edition":"","Line of Business":{"code":"","label":""}}]

Historical Number

70917

Document Information

Modified date:
15 June 2018

UID

swg21348642