If function Operand question

[Marc Osborne]

Good afternoon

I would like to have this equation:

if(YARD="H",(AVG_MO*9.16)/2.25,"")

Return the numeric calculation when the YARD field has the letter "H" in it and a blank if not. I get an operand type error whether the calculated field is numeric or character. Can someone help please?

Thanks,

Marc

[Grant Perkins]

Hi Marc,

Assuming AVG_MO is numeric and you are populating a numeric field try 0 (zero) rather than "" (nothing) for your value for yard not equal to H.

I have not set it up to test the result but it looks a likely candidate. If not let us know and we can search for other suggestions.



Grant

[Marc Osborne]

That did the trick. Thank you.