.00 instead od 0.00

Focal Point

.00 instead od 0.00

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

January 11, 2007, 02:15 AM

Aditya

.00 instead od 0.00

Hi,

I am firing a query that fetches the data from the database in which one field value is 0.00.But when the values are shown in the reports they become .00.I am not able to understand why the initial 0 value is truncated.Kindly help me.

Regards,
Aditya

January 11, 2007, 03:16 AM

Pete

A.,

Just add

SET CENT-ZERO=ON

at the beginning of your report

Hope this helps

P.

D: WF 7.6.2 P. : WF 7.6.2 on W2003
------------------------------------------------------------------
I see myself as an intelligent, sensitive human, with the soul of a clown which forces me to blow it at the most important moments.

-Jim Morrison-

January 11, 2007, 03:48 AM

Aditya

Thanks Pete.Its working now.

Regards,
Aditya

January 11, 2007, 05:44 AM

OPALTOSH

That's normal WebFOCUS behaviour. If you want leading zeros you can use the L edit option but then you will get lots of zeros before the decimal point.
If you specifically want to display 0.00 for a zero value then you would have to do it using DEFINEs or COMPUTEs where you convert the numeric field to an alpha.