Null = 0.00

[Yustrn]

I'm sure this is a stupid question so I aplogize in advance, but I need to know the if than for null

I am assuming it's If {whatever.rot} is null then "0.0000" else {whatever.rot}

If someone could please help I would highly appreciate it.

Thank You

This is using crystal 10

 

[synapsevampire]

Try:

If isnull({whatever.rot}) then
"0.0000"
else
{whatever.rot}

this assumes that the field is a string sinbce you're intentionally wrapping the first 0 in quotes.

Also note that nulls need to be checked for first in formulas, as performed here.

If the field is a numeric use:

If isnull({whatever.rot}) then
0
else
{whatever.rot}

And then you can right click the field and select format field to set the number of decimal places.

-k

 

[lbass]

if isnull({table.field}) then
0 else
{table.field}

-LB