Show % as .9999 with NO Leading 0

[Dr. Siewert]

Have a field that is now .28000 which is my % field. I want to show the field as .2800 with no leading zero. I've been able to show it as 0.2800, but having difficulty showing it as just .2800.

MONARCH 9.01

Harald

[Data Kruncher]

Hi Doc,

Monarch just won't let you do this with a normal numeric field type, but if you use a Character calculated field with:
LSplit(trim(str(Pct,6,4)),2,"0",2)

Assuming your Pct is always 0.xxxx, this formula will convert 0.2800 to .2800 for you.

Kruncher