Crystal Reports Linking where table has Null Values

[AntonioPerera]

Hi,

I have linked the sequence number field in 2
tables however sometimes one of the tables
may contain null values.

I have used a left outer join to link these fields.

The table is also linked perfectly to a header
sequence.

When I write the following formula and place it in the
report the null values appear as blanks even though I have
specified it in the formula to be 0

Here is the formula :

if {QUANTITYRETURNED} > 0 then
({QUANTITYRETURNED}*{UNITCOST})
ELSE 0

Any suggestions on how I can make the null values to appear as 0 if it is null ?

 

[MisterMo]

null and zero values are different and therefore are intepreted differently by CR

try

if isnull({QUANTITYRETURNED}) = false and {QUANTITYRETURNED} > 0 then
({QUANTITYRETURNED}*{UNITCOST})
ELSE 0

Mo

 

[AntonioPerera]

Thanks Mo, it worked...

 

[MisterMo]

Glad it worked

Mo