Creating Dynamically Formatted Fields

I knew this was too good to be true!

Here's an example from the 5.3.2 manual:

DEFINE FILE CAR
MYFORMAT/A8=DECODE COUNTRY ('ENGLAND' 'P15.2C' 'JAPAN' 'P15.0' ELSE 'P15.2M');
END

TABLE FILE CAR
SUM SALES/MYFORMAT 
BY COUNTRY
-*ON TABLE PCHOLD FORMAT EXL2K
END

Uncomment the format EXL2K line and everything falls down - no decimal places, no commas.

Would someone please try this code on WF newer than 5.3.2?

Thanks.

quote:

DEFINE FILE CAR
MYFORMAT/A8=DECODE COUNTRY ('ENGLAND' 'P15.2C' 'JAPAN' 'P15.0' ELSE 'P15.2M');
END

TABLE FILE CAR
SUM SALES/MYFORMAT
BY COUNTRY
-*ON TABLE PCHOLD FORMAT EXL2K
END

works in 7.1.6 - both for HTML and for EXL2K

I just tried it on 7.6.2 and it worked. HTML and EXL2K output looked the same

Worked in 7.1.5 !

Except that for Japan instead of '78030.' the value displayed was '78030' (without the dot like in HTML).

Thanks everyone. Now I'll wait for my client to upgrade...

COUNTRY SALES
ENGLAND 12,000.00
FRANCE $.00
ITALY $30,200.00
JAPAN 78030
W GERMANY $88,190.00

What I get on 7.6.2 in excel, changed the P to D and here's what I get.

COUNTRY SALES
ENGLAND 12,000.00
FRANCE $.00
ITALY $30,200.00
JAPAN 78,030
W GERMANY $88,190.00

I'm assuming what you'd like is currency??

I have a report where I'd like to display a measure with a different numeric format based on a BY field. This works in HTML, but does not in EXL2K.

(It would have been great if the people that wrote the manual tried the supplied example in different formats, then the bug would have been found a lot sooner than waiting for a customer to find it).

Don't you know we are quality assurance personnel?