Error in Formula "Number is Required Here"

[titans4771]

I have the below code:

If isnull({Command.missingdocs}) or {Command.missingdocs} ="" then 'NULL'
Else {Command.missingdocs}

What I am trying to do is have the formula display "Null" if the row is empty. The value of that field is a number there fore the error is saying I need a number where I have ""?

Any suggestions?

Thanks!

 

[Madawc]

Try

If isnull({Command.missingdocs}) or {Command.missingdocs} = 0 then 'NULL'
Else ToText({Command.missingdocs})

I assume the field is numeric.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[titans4771]

Great! That works, but now the value is coming back with 2 decimal places (2.00)? I tried converting it tonumber, but that doesn't work. Also I am using version 11.

Thanks!

 

[lbass]

If isnull({Command.missingdocs}) or
{Command.missingdocs} = 0 then 'NULL'
Else ToText({Command.missingdocs},0,"")

-LB

 

[titans4771]

Thanks a million!!!