7 Replies Latest reply on Mar 3, 2015 8:51 AM by schamblee

    I can't figure out why this calculation is not working. I have never used the "not" and "and"...

    tdeppen

      Post

      I can't figure out why this calculation is not working. I have never used the "not" and "and" logical operators, so this is a first on both accounts in one simple if statement. I am trying to automatically populate a field based on if the "inv flag" filed is not empty and if the "dept.no" equals anything BUT "870130110". The formula below is not working.

      If ( 
      INV FLAG > "" and DEPT.NO. = not "870130110" ; "Inventoried Order" ; ""
      )