converting nulls to zero

[uksub]

can someone walk me through the process of converting nulls to zeroes on my reports.

 

[pgtek]

hi

create formula

@Conversion

if
isnull({your_filed}) then 0
else
{your_field}

cheers

pgtek

 

[uksub]

Well i eventually used the Reports Option "Convert Null fields to Default"... but for some reason I had to disable the "Use Index or Sever for speed" option. When this option was enabled, the "Convert Null ..." option was disabled. Do you know why that is?

 

[pgtek]

hi
what version are u using of crystal?

pgtek

 

[uksub]

I'm using version 8.5

 

[pgtek]

hi

lets start all over
do not use your
Reports Option "Convert Null fields to Default"...
leave that alone

is your field a string or numeric?

pgtek

 

[uksub]

it's numeric...

:-D

 

[pgtek]

Ok
create formula

@Conversion

if
isnull({your_field})Or {your_field} = 0
then 0
else
{your_field}

 

[pgtek]

if
this does not work
try this one
if
isnull({your_field})Or {your_field} = -1
then 0
else
{your_field}