SET CDN=ON
TABLE FILE CAR
PRINT CAR
COMPUTE SALES/D12.2=SALES;
BY COUNTRY 
ON COUNTRY RECAP
   V_SAL/D12.2=SALES;
ON COUNTRY SUBFOOT
" "
"<V_SAL"
ON TABLE SET ONLINE-FMT 'PDF'
ON TABLE SET STYLE *
HEADALIGN=BODY,
GRID=OFF, $
ENDSTYLE
END
 

quote:

When i run this piece of code :

the sales totals are noted : 999.999,99

but when i change the online-format to EXL2K

it becomes 999,999.99 but only for the totals

Any idea how i can tackle this??

quote:

CDN
The CDN parameter specifies punctuation used in numerical notation.

Continental Decimal Notation (CDN) is supported for output in TABLE requests. It is not supported in DEFINE or COMPUTE commands.

The syntax is:

SET CDN = option
where:

option
Is one of the following:

ON uses CDN. ON 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. ON should be used for Germany, Denmark, Italy, Spain, and Brazil.

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

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. SPACE should be used for France, Norway, Sweden, and Finland.

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. QUOTE should be used for Switzerland.

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.

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.

  
-SET &ECHO=ALL;
SET CDN=ON
DEFINE FILE CAR
  XSALES/D12.2S = SALES;
END
TABLE FILE CAR
SUM 
  XSALES
BY LOWEST COUNTRY
ACROSS LOWEST SEATS
ON TABLE HOLD AS HOLD1 FORMAT HTML
END
-RUN
SET HTMLFORMTYPE=XLS
-RUN
-HTMLFORM BEGIN
!IBI.FIL.HOLD1;
-HTMLFORM END
-EXIT

  
-SET &ECHO=ALL;
SET HOLDLIST=PRINTONLY
TABLE FILE CAR
SUM 
  SALES/P18.2C
BY LOWEST COUNTRY
BY LOWEST SEATS
WHERE SALES NE 0;
  ON TABLE HOLD AS HOLD1
END
-RUN
DEFINE FILE HOLD1
 XSALES/A22   = PTOA(SALES, '(P18.2C)', 'A22');
 YSALES/A20   = LJUST(22, XSALES, 'A20');
 SALES_1/A3   = GETTOK(YSALES, 20, 1,  ',', 3, 'A3');
 SALES_2/A3   = GETTOK(YSALES, 20, 2,  ',', 3, 'A3');
 SALES_3/A3   = GETTOK(YSALES, 20, 3,  ',', 3, 'A3');
 SALES_4/A3   = GETTOK(YSALES, 20, 4,  ',', 3, 'A3');
 SALES_X/A2   = GETTOK(XSALES, 22, -1, '.', 2, 'A2');
 NEW_SALES/A20 = IF SALES_4 NE '' THEN SALES_1 || '.' || SALES_2 || '.' || SALES_3 || '.' || SALES_4 || ',' || SALES_X ELSE
                 IF SALES_3 NE '' THEN SALES_1 || '.' || SALES_2 || '.' || SALES_3 || ',' || SALES_X ELSE
                 IF SALES_2 NE '' THEN SALES_1 || '.' || SALES_2 || ',' || SALES_X ELSE
                                       SALES_1 || ',' || SALES_X;
END
TABLE FILE HOLD1
SUM 
-*  XSALES
-*   SALES
-*   SALES_1
-*   SALES_2
-*   SALES_3
-*   SALES_4
-*   SALES_X
  NEW_SALES
BY LOWEST COUNTRY
ACROSS LOWEST SEATS
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET GRID ON
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=NEW_SALES, JUSTIFY=RIGHT,$
ENDSTYLE
END
-EXIT

-SET &ECHO=ALL;
-SET CDN=ON;
-DEFAULT &COUNTRY = 'FOC_NONE';
-SET &VCOUNTRY = IF &COUNTRY EQ ' ' THEN 'FOC_NONE' ELSE &COUNTRY;

DEFINE FILE CAR
DEALER_COST2/F10.2 = DEALER_COST;
TOT_DEALER/D10.2 = DEALER_COST + 1
END
TABLE FILE CAR
SUM
DEALER_COST2
RETAIL_COST
BY COUNTRY
BY CAR
WHERE COUNTRY EQ '&VCOUNTRY';

FOOTING
"<TOT_DEALER"
ON TABLE SET ONLINE-FMT EXL2K
END