Region forumula - What am I doing wrong?

I'm using the formula tool to assign a region to each name. Here is how it's structured. The issue I'm having is everything is being called 'East' in the output field, even 'Name 4-6'.

Output Column = Region

Formula:

IF [Field Rep] = 'Name 1'
or 'Name 2'
or 'Name 3'

THEN 'East'

ELSEif [Field Rep] = 'Name 4'
or 'Name 5'
or 'Name 6'

THEN 'West'

else 'Unknown'

ENDIF

Output

Accepted answers

LordNeilLord

Hey @BigDataGeek

Try:

IF [Field Rep] in ( 'Name 1', 'Name 2', 'Name 3') THEN 'East'

ELSEif [Field Rep] in ( 'Name 4', 'Name 5', 'Name 6' )THEN 'West'

else 'Unknown'

ENDIF

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

All comments

LordNeilLord

Hey @BigDataGeek

Try:

IF [Field Rep] in ( 'Name 1', 'Name 2', 'Name 3') THEN 'East'

ELSEif [Field Rep] in ( 'Name 4', 'Name 5', 'Name 6' )THEN 'West'

else 'Unknown'

ENDIF

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

BigDataGeek

Thank you sir! Worked well and is easier than my previous code. Didn't know about the 'in' function.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335