Skip to main content
Question

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

  • April 21, 2018
  • 0 replies
  • 58 views
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
    This topic has been closed for replies.

    • ChrisChris
    • Registered
    • April 21, 2018
    That last ampersand, if you really do have it, should go.
    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • April 23, 2018
    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?
    Terms & ConditionsAccessibility statement