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.
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
Thanks for posting this, can you use && in a regular IF THEN ELSE ?
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?
=IF(AND([X]="Y",[X1]="N",[X2]="N"),"Y","N") - would make more sense, apologies.
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.