Crystal Report Null values - Doubt

[nithyaa1]

When there are some null values in the backend column,i should print 0(Zero) , in the lay out.So please suggest me a idea how this can be done using formula editor......

Then i am calculating total for each row also,so this null field gives me a problem there also

How to handle null field........

Expecting reply ..............

Regards,
nithyaa1.

[si_the_geek]

In the formula editor I believe you can do this:

If IsNull({Field}) Then
  "0"
Else
  {Field}

(just replace the word Field with the appropriate field name)

Then you place the formula onto the report (instead of the field).

For your total just add the formula results together, I'm not sure how you add formulas, possibly: {@formula} + {@formula}