[SOLVED] Leading Zero

Focal Point

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

April 21, 2004, 08:45 PM

Leo L

[SOLVED] Leading Zero

I was wondering how you would go to get 1 leading zero for a decimal number that is below 1.

I have numbers that are .54 .23 and I want to display 0.54 (only 1 leading zero if the number is below 1

the field is FIELDNAME/D12.2

is there something to do this automatically?

thanks,

Leo

This message has been edited. Last edited by: Kerry,

April 21, 2004, 10:37 PM

Mikel

Yes, you can use the SET CENT-ZERO command (FOCUS 7.2 or iWay 5.1 and up).

SET CENT-ZERO=ON<br />TABLE FILE CAR<br />  SUM SALES/D15.2<br />  BY COUNTRY<br />END

Regards,
Mikel

April 22, 2004, 01:17 PM

Leo L

It was exactly what I needed.

thanks!

Leo

May 20, 2011, 05:03 PM

Doug

Ditto:

quote:
It was exactly what I needed.

I knew that (but brain freeze got in my way

)

May 22, 2011, 06:09 PM

Waz

Its all in the documentation, and the name is so obvious.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!