community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

IF AND

Highlighted
Meteor

okay just tried case and that works

 

case
when "Billings$"<"BillingsCost$" then
"Billings$"-"BillingsCost$"
else 0
end

 

However IF has some bug in alteryx maybe .

Thanks for all the support so far.

BR

Brij

Asteroid

Thanks for posting this, can you use && in a regular IF THEN ELSE ?

Meteor

Hi There,

 

Taking the same logic, how would I go about writing a formula with 3 conditions.

 

I am trying to replicate an excel formula which would read:

 

=IF(AND([X]="Y",[X]="N",[X]="N"),"Y","N")

 

Tried using the IF ELSEIF function but this isn't right, any thoughts?

Meteor

=IF(AND([X]="Y",[X1]="N",[X2]="N"),"Y","N") - would make more sense, apologies.

Meteor

Solved guys.

 

I didn't realise you could simply use AND in an IF THEN ELSE formula in Alteryx.

 

IF ([X]="Y" AND [X1]="N" AND [X2]="N") THEN "Y" ELSE "N" ENDIF - Worked.

 

 

Labels