Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

And If Statement

8 - Asteroid


I am trying to write a formula that says: if column C does not equal "NOT MAPPED" and column F does not equal "00584" and column F does not equal "00360" then return the value "y" else return "n". 

The formula that I am using now looks like this: if [Product Grouping] != "NOT MAPPED" and [bu] != "00584" and [bu] != "00360" then "y" else "n" endif 

However, this is not returning the correct amount of "y" and "n" records. 

Is there something wrong with my syntax or another way to create this formula?

Thank you!!

Alteryx Certified Partner
Alteryx Certified Partner

Hi @grsomer  try this for the formula IF [Product Grouping] != "NOT MAPPED" and [bu] NOT In ('00584','00360') and THEN 'y' ELSE 'n' ENDIF . If this does not work could your provide some sample data in order to test any possible solutions?