Forum Discussion

StephenAnguiano's avatar
StephenAnguiano
Qrew Cadet
7 years ago

Help in using ""<>"" in a formula.

I am trying to find mismatches when comparing two fields. The [TO_iM_StaticPressureCFM] is numeric field while the [TO_CalculatedCFM] field is a formula - numeric field. The below script is not working correctly. I guess I am not using the "<>" correctly.

If([Customer - Related Client]=3 and [AirFlowMethodID]=2 and [TO_iM_StaticPressureCFM]<>[TO_CalculatedCFM],"Does not match"&"\n")&

Thanks
Formulas and functions

8 Replies

Sort By
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago
    That last ampersand, if you really do have it, should go.
  • EvanMartinez's avatar
    EvanMartinez
    Qrew Elite
    7 years ago
    HI Stephen,

    When that formula is not working correctly are you getting a specific error message back when trying to save or are you getting a wrong output?
    • StephenAnguiano's avatar
      StephenAnguiano
      Qrew Cadet
      7 years ago
      Evan,

      I am not getting an error message. I am getting the wrong results it is returning matches and I want to see mismatches.

      Thanks
      Stephen
    • EvanMartinez's avatar
      EvanMartinez
      Qrew Elite
      7 years ago
      What type of fields are [TO_iM_StaticPressureCFM] and [TO_CalculatedCFM]
    • StephenAnguiano's avatar
      StephenAnguiano
      Qrew Cadet
      7 years ago
       [TO_iM_StaticPressureCFM] is a numeric field and [TO_CalculatedCFM] is a formula - numeric field.