formula won't add correctly

[mgossman]

I have what I thought was a simple formula, but it isn't adding for me. I have 2 formula fields Formula1=hours*120.00, Formula2 = hours*138.00. The Formula I'm having trouble with is Formula3=Formula1 + Formula2. It only calculates if both Formula1 and Formula2 have a value > 0 in them. If either one is 0, the formula returns nothing. What am I doing wrong?

 

[dgillz]

Most likely, you have nulls, not zeros, in one of your fields. Click on file, options, reporting tab, and make sure "convert null values to default" is checked.

Also, always include your version of crystal in your post. Correct answers vary by version, and newer versions offer more options.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[mgossman]

I've tried that already, I've also tried including a tonumber statement in my formula for Formula1 and formula2 as follows: tonumber(formula1) + tonumber(formula2)
I'm running Crystal 9...

 

[lbass]

Please post your actual {table.field} and identify their datatypes, and also post the contents of your actual formulas.

-LB

 

[Madawc]

As dgillz says, you are probably getting nulls. Try modifying your formulas, e.g. Formula1 as

if not isnull(hours)
and hours <> 0
then hours*120.00
else 0

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10