Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor

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
11 - Bolide

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