August 01, 2005, 01:37 PM
<new2focus>Problem displaying decimal value
Could anyone tell me why is the report doesn't display the decimal part correctly?
In Oracle table: unit_price number(6,4) and
On Master file : FIELDNAME=UNIT_PRICE, ALIAS=UNIT_PRICE, USAGE=D20.2!D, ACTUAL=P8, MISSING=ON, $
When I display this field on the report it always shows .00 for the decimal part even though
Ex: 1.20 is being displayed as $1.00
.65 is being displayed as $.00
Also how can I display .65 as $0.65 instead of $.65?
Any help will be truly appreciated.
August 01, 2005, 03:54 PM
<new2focus>I changed the master file description to USAGE=D20.4M, ACTUAL=P8.4 and its displaying the decimal part now.
I am still not able to display .65 as $0.65. Could anyone help me figure this out?
August 01, 2005, 04:13 PM
HÃ¥kannew2focus,
SET CENT-ZERO=ON will do the trick
August 01, 2005, 05:07 PM
<new2focus>SET CENT-ZERO=ON did the job!!!
Thanks a lot Lidholm ... Have a gr8 day!