Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula Tool Logic

MSharm83
5 - Atom

Hi Experts,

 

I am fairly new to Alteryx, And got stuck with one logic. If I can explain it correctly below is the requirement.

 

Mandatory condition ;

If Country = China  then (Number of person)* (Hour Worked) where Country = China else (Hour Worked) Endif

 

 How can I write this logic in Alteryx?

 

Help Highly Apriciated.

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@MSharm83 
A sample input will be better.
But a simple If statement inside the Formula tool should work for you.
Just an example below.

1119-MSharm83.PNG

Labels
Top Solution Authors