Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

If condition

mmustkee
8 - Asteroid

Hi team,

 

I am receiving an error while applying if formula. I want if my reason column is = ACCEPTED, Offered, Permit, Asked, Given, shared, added, Taken then amt column should be '0' else should remain the same.

PFA data and workflow

Thanks,

Mohamamd Mustkeem

Emil_Kos
15 - Aurora

Hi @mmustkee,


I have updated your workflow.


I also made some changes in the formula to make it cleaner:

 

if [Reason] IN ('ACCEPTED' ,'Offered','Permit','Asked') THEN 0 else [Amt] ENDIF

 

Emil_Kos_0-1614001321928.png

 

Assaf_m
10 - Fireball

Hi @mmustkee 

 

Check attached solution

 

Assaf_m_0-1614001440745.png

let me know if it works for you

mmustkee
8 - Asteroid

Great Help.

 

That worked for me.

mmustkee
8 - Asteroid

Yes, Asaf it worked for me.

 

Thanks,

Mohammad Mustkeem

Labels