AnsweredAssumed Answered

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

Question asked by tdeppen on Mar 2, 2015
Latest reply on Mar 3, 2015 by schamblee

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" ; ""
)

Outcomes