ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

AND Function does not work

9 - Comet

Hi team,


I am trying to use AND formula which is similar to AND function present in MS Excel. Could you guide me how to use the same? I am in dire need.


Let me know your best approach to this.


Thank You,

Ashis Sanpui

17 - Castor
17 - Castor

In Alteryx expressions: the "AND" ("&&" also works) is an operator and not a formula. Think of it as a "+" for conditions.



In Excel: AND([A]=1,[B]=1)


In Alteryx: [A]=1 AND [B]=1

or ([A]=1 AND [B]=1) if the parenthesis help.

9 - Comet

Thank you @CharlieS for the solution. It did work for me.