TABLE FILE CAR
 SUM
 COMPUTE PERC/F7.2%=DEALER_COST/SALES*100;
 BY COUNTRY
 ON TABLE PCHOLD FORMAT EXL2K
 END

quote:

doesn't act as a percentage column?

quote:

HEllo Peter,

I did some more research and it seems indeed that the way the percentage is
represented in excel has changed. Several customers had the same issue, but
programming looked into it and will not change the behaviour, since it was not
correct before and now it is.
This is the official statement I found:
The change for the Excel format now includes an escape character that
prevents Excel from calculating the percent (\%). This change creates
consistency across the WF output options in that the percent is not
calculated when using the percent display option.

In the early 53x series there was an error in EXL2K with % formats.
Use of the % format together with EXL2K would give values that looked
correct in individual Excel cells, but were off by a factor of 100 when
the cell value was used in an Excel formula such as SUM() or AVERAGE().
For example:
TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
COMPUTE RATIO /D9.2 = DEALER_COST /RETAIL_COST *100;
COMPUTE PRCNT /D9.2% = DEALER_COST /RETAIL_COST *100;
BY COUNTRY BY CAR
ON TABLE PCHOLD FORMAT EXL2K FORMULA
END
would produce the following output:
RATIO PRCNT
83.24 8,324.47%
83.70 8,369.75%

Having Excel format a Percent value causes Excel to multiply it by 100.
The value for PRCNT should display as 83.24% not 8,324%. Therefore the
way we ask EXL2K to format the output was changed to only append a '%'
character to the end of the cell, and not look at the value in the cell
as a Percent. This allows the value displayed to have a correct internal
value, and still match WebFocus formatting.

This change in behavior is a correction rather than a problem.
You can avoid this behavior if you take the value and use FTOA to
convert it to an alpha string and concatenate the % symbol at the end of
it.

  
GTNSPCT01/P14.2% = ((CAMT01 - PAMT01)/PAMT01)*100;
    AGTNSPCT01/A21 = PTOA(GTNSPCT01, '(P14.2%)', AGTNSPCT01);