This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am new to Alteryx, so I am guessing this is something simple; but i cannot figure it out. (I have tried several variations of iif and if-then, with parenthesis everywhere). When I run these two statements independently, they each work, but when I try to run them together with an OR, everything comes back as "No". Can someone give me some guidance?
Combining logical negations is always tricky. The formula you have only works if your input contains both Operation and Center. Anything else causes one of the or clauses to be true so the entire statement is true returning 'No'
Is this the result you want? If you actually want it to return yes, if it contains 'Operation' or if it contains 'Center' follow @CharlieS.
It gets a little tricky because this is only part of a larger formula that I have; where if a few other conditions aren't met either it will default to "Yes". So ideally I could use a logic like this to exclude instead of include. Does that makes sense? But I am open to any suggestions; i am just starting to learn. Thank you
Oh, that is very helpful. Thank you! I am not sure how to get around this, as this is part of a larger formula where ultimately the default condition is "Yes". So I want to the result to be "Yes" if it contains either Center or Operation or if it contained Center&Operation.