Problem getting sum field to calculate if one field is empty

[neronikita]

I am pulling reports in Crystal 2008 from an Access 2007 database. I have a field that sums up three fields in the database. If one of those fields is empty, it doesn't display the total for the other fields, it leaves the sum field empty. Is there any way to resolve this? I figured out to use the NZ function within access in the same scenario, but haven't found an equivalent for Crystal.

Thanks!

Di

 

[Deepravs]

Fields are empty, you mean NULL in this case.

If it is so,

you can replace NULL with 0 so that when you add up these you get correct summary.

You can use REPLACE, ISNULL functions to replace blank space to 0

(As these take string values only, use ToText and then ToNumber conversions)

 

[neronikita]

thanks. So how would I add that to this formula?

({@MilesCharge}+{@StopCharge}+{TripInfo.FuelCharge})

I've never done those conversions.

Thanks,

Di

 

[lbass]

(
if isnull({@MilesCharge}) then
0 else
{@MilesCharge}
)+
(
if isnull({@StopCharge}) then
0 else
{@StopCharge}
)+
(
if isnull({TripInfo.FuelCharge}) then
0 else
{TripInfo.FuelCharge}
)

-LB