Crystal Reports Help

In creating a Crystal report, I created formula fields called Total1
and Total2. Total1 totals line 1 and Total2 totals line 2. This
works fine. I then created TotalOpp which simply adds up Total1 and
Total2. This works fine too as long as both Total1 and Total2 have
data, but if either is Null it sets the result for TotalOpp to Null
instead of the value for the Total field that wasn't Null.

How do I fix this?

Andrew
Wed Mar 03 13:39:03 CST 2004

In Crystal - go to File menu.
Select Report Options and Click button "Convert NULLS to
default". This should fix your issue.

>-----Original Message-----
>In creating a Crystal report, I created formula fields
called Total1
>and Total2. Total1 totals line 1 and Total2 totals line
2. This
>works fine. I then created TotalOpp which simply adds up
Total1 and
>Total2. This works fine too as long as both Total1 and
Total2 have
>data, but if either is Null it sets the result for
TotalOpp to Null
>instead of the value for the Total field that wasn't Null.
>
>How do I fix this?
>.
>