title: How to write a Crystal reports formula comparing string to number field
body: <p>I have three fields. Two of the fields I want to compare to each other to make sure that they equal each other. If they don't equal I want another field within the report to display 'ERROR' instead of the Serial number that it's supposed to display if the first two fields are equal to each other. </p>
  
  <p>I want to compare these two fields</p>
  
  <p>{V_LMINVTRY_MANUFACTURED.WORKORDER_ID}) &amp;  {WORKORDER.FG_LOTNO}</p>
  
  <p>And if they equal to each other I want 
  {V_LMINVTRY_MANUFACTURED.CSERIAL} to display else if they don't equal I want it to display "ERROR' in the {V_LMINVTRY_MANUFACTURED.CSERIAL} field.</p>
  
  <p>Crystal Reports 2013</p>
  
  <p>So, I had something like this as my formula but even though both fields are string fields it's asking for a number via an error for the {WORKORDER.FG_LOTNO} field when I check the formula for correctness. </p>
  
  <p>if({V_LMINVTRY_MANUFACTURED.WORKORDER_ID}) = {WORKORDER.FG_LOTNO} then 
    {V_LMINVTRY_MANUFACTURED.CSERIAL}
  else
    'ERROR'</p>
  
  <p>Want to display an error on the report if the fields do not match.</p>