Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

If conditional formula error (Tax Codes)

NehaNevrekar
8 - Asteroid

Hi Team,

 

I am trying to apply an 'If' conditional formula in alteryx to check the tax codes with 5 other columns. However, I am not getting the result as expected.

 

I am attaching the sample data and the workflow I have prepared. 

 

Would appreciate an immediate reply.

 

Thank you!

 

Attachments

  1. Input data
  2. Workflow
  3. Output file (Errors highlighted in red)
  4. Actual Tax codes conditions
3 REPLIES 3
Raj_Singh1
9 - Comet

HI Neha @NehaNevrekar 

 

 

Please see attached solution workflow and screenshot. hope it works, if not then please let me know. I have only added extra brackets for or condition as you want all of them to go together. but if it still doesnt work then please let me know..

tAX ERROR.png

 

 

NehaNevrekar
8 - Asteroid

Hey Raj,

 

Thanks a lot. It worked for me.

 

Regards,

Neha

Raj_Singh1
9 - Comet

Thanks for accepting as solution 🙂

Labels