Null Case and Numerical Field 1

[sfujii]

Hi,

I have a numerical field populating a crystal report. I wrote a formula like the following:

If (tbl.field) = "" then
""
else
CStr(tbl.number)

so that tbl.number will be empty when tbl.field is null and a number otherwise. tbl.number has three decimal points but since I had to convert it to a string, it only displays two decimal points.

Could anyone help me get tbl.number to display three decimal points on the report? I am using CR .NET.

TIA!

 

[synapsevampire]

Try:

If (tbl.field) = "" then
""
else
totext((tbl.number),0,3)

-k