If NULL then return empty

[mycrystalbaby]

I am using CR X with SQL 8.0.
I would like to write a formula to make sure, if any of the field is NULL then return empty.
If A=10 and B=NULL

A-B should return NULL.
How can I achieve this in Crystal X.
Thanks in advance.

 

[synapsevampire]

Try:

Create a formula with nothing in it.

Then reference that formula as in:

IF ISNULL({table.a})
or isnull({table.b}) then
{@MyNullOutput}
else
totext({table.a}-{table.b})

-k

 

[mycrystalbaby]

Thank you so much
Highly appriciated.