How to make a zero?

[Yustrn]

What I need is a Formula or a way to tell Crystal that if a field is blank then I want it to display a Zero in that field, I need this to still work if I export the data out to .CSV

I've tried a few formula's but can't make it work, please help.

and I'm in 7.0

 

[stormtrooper]

if isnull({your_field}) or ({your_field}) = " "
then "0"

 

[Yustrn]

If isnull ({ROTmyfile.Tax 6 Rate}) or ({ROTmyfile.Tax 6rate})= " " then "0"

This is what I put in, and when I check the formula it says that a number is required between the = "

If I put something wrong let me know

 

[mbarron]

stormtrooper's formula will work if you are evaluating a string field. It appears you are evaluating a number field.

Try using this formula:
If isnull ({ROTmyfile.Tax 6 Rate) then 0

If that doesn't work try going to File/Options.../Reporting Tab/Check the box for "Convert NULL Field Value to Default"

Mike

 

[Yustrn]

Mike,

I found the options thing in the HELP feature did it and it worked, then I saw your answer...just proves again how great this site it.. Thanks for the help from both of you.

 

[stormtrooper]

Yes, mbarron's theory. It does sound like you are using numbers here.