I need to apply following formatting option to EXCEL Output.
I have a numeric Column which when negative should be displayed in brackets.

I am able to do it in HTML output.
The same, when i apply to EXCEL, it is not working.

I would appreciate if, some one replies with an example.

Thanks
Viswakanth

5.2.3 on Windows:


TABLE FILE CAR
SUM COMPUTE MINSALE/D12.2B = -SALES;
BY COUNTRY
ON TABLE PCHOLD FORMAT excel_option
END

Works well for the excel_option: EXL2K, but does not work for: EXL97, and EXCEL.
You can also compute the alpha field for report, adding braces if the numeric value is negative.

This message has been edited. Last edited by: <Mabel>,

I am working on 436 developer studio.
Following is the code, which i have written.
TABLE FILE CAR
PRINT
CAR
MODEL
DEALER_COST
SEATS
COMPUTE FINAL_CT/P10.2B = -100000+ DEALER_COST;
BY COUNTRY
ON COUNTRY SUBFOOT
"Total <+0> <+0> <+0> "
ON TABLE SET ONLINE-FMT EXL2K
END

But i am not able to get the bracket for the negative terms.
Please help me to cross this hurdle.

Thanks
Viswakanth

Viswakanth,

Your code works on my computer as expected (negative numbers are in brackets).
On the IBI TechSupport site it is stated that it is known problem solved with Release 4.3.6 Service Pack 9.

Regards
Grzegorz

Hai grzegorz

Can you point me to the link, which states that, it is a known BUG.

Thanks for your Quick response.

Viswakanth