2 Replies Latest reply: May 15, 2014 10:02 AM by Marc Osborne RSS

    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