In my crystal report ,I am trying to display 'N/A' if field of datatype number has null value fetched from stored procedure else the value has to converted to text as shown below. If not converted to text it is throwing error but if converted to text then decimal value gets round off. I want to display exact decimal values as in database. Below is the code written in formula for field value. How to display exact decimal value in this condition where 'N/A' is also required in null case.
In formula :

if isnull (Field.VALUE}) then "N/A"
else (totext({Field.VALUE}))

eg : if value is 12.345 it displays 12.35

required value : 12.345
Different values will have different decimal places, not specific to any fixed decimal place.

given your requirements that the number of decimal places changes, randomly, I do not see a solution.

As you have noticed, Crystal needs both parts of a IF clause to return the same type...numeric, date, boolean, or string.

the only thought that comes to mind is not a pretty to code, and would be something like this...and there is probably a more elegant solution as well...

if totext({field.value}, 1, "") + "0" > totext({field.value}, 2, "") then
if totext({field.value}, 2, "") + "0" >
    totext({field.value}, 3, "") then


to however many places you want. It won't be pretty...

It is a thought

Since this is just a display issue can also place two fields on top of each other, one numeric and the other a text field that is "N/A" and conditionally suppress each field around the null value of your original field...assuming the original number field was displaying to your liking.