Using the Continental Decimal Notation (CDN) Parameter

Topics: Learn More

The Continental Decimal Notation (CDN) parameter specifies punctuation used in numeric notation. Continental Decimal Notation is supported for output in report requests. It is not supported in DEFINE or COMPUTE commands. The CDN parameter has been added to the Set canvas, as shown in the following image.

Possible values are:

COMMAS_DOT (alias OFF) turns CDN off. For example, the number 3,045,000.76 is represented as 3,045,000.76. COMMAS_DOT is the default value. COMMAS_DOT should be used for the USA, Canada, Mexico, and the United Kingdom.

DOTS_COMMA (alias ON) uses CDN. Sets the decimal separator as a comma and the thousands separator as a period. For example, the number 3,045,000.76 is represented as 3.045.000,76. DOTS_COMMA should be used for Germany, Denmark, Italy, Spain, and Brazil.

Note: Numeric parameters that use CDN DOTS_COMMA must be separated by a comma followed by a space in calls to functions.

QUOTES_COMMA (alias QUOTE) sets the decimal point as a comma and the thousands separator as an apostrophe. For example, the number 3,045,000.76 is represented as 3'045'000,76. QUOTES_COMMA should be used for Switzerland.

QUOTES_DOT (alias QUOTEP) sets the decimal point as a period and the thousands separator as an apostrophe. For example, the number 3,045,000.76 is represented as 3'045'000.76.

SPACES_COMMA (alias SPACE) sets the decimal point as a comma, and the thousands separator as a space. For example, the number 3,045,000.76 is represented as 3 045 000,76. SPACES_COMMA should be used for France, Norway, Sweden, and Finland.

Note: If the display format of a report is Excel 2000 or later, Continental Decimal Notation is controlled by the settings on the computer. That is, numbers in report output are formatted according to the convention of the locale (location) set in regional or browser language options.