Focal Point
Problem displaying decimal value

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7351088331

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Ã¥kan
new2focus,

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!