Using boolean Logic

Hi Everyone, Im new to Alteryx and trying to do a change within one field dependent on a number of the other fields. The formula I have so far is this

IIF([ServiceLine] = "Tax" 
AND 
([Sector] = "Life Sciences" OR "Professional Firms & Services" OR "RE, Hospitality & Construction")
AND 
[FSO WAM Filter] = "Other" , "UK Additions - Tax" , [FSO WAM Filter] )

Im looking for all rows where ServiceLine = Tax, FSO WAM Filter = Other and then Sector equals either "Life Sciences" OR "Professional Firms & Services" OR "RE, Hospitality & Construction" but this doesnt seem to work, any ideas?

Regards

Jon

Preparation

Accepted answers

JohnJPS

Hello Jon!

Would something like this work:

IIF ([ServiceLine] = "Tax" 
AND 
([Sector] IN ("Life Sciences","Professional Firms & Services","RE, Hospitality & Construction"))
AND 
[FSO WAM Filter] = "Other" , "UK Additions - Tax" , [FSO WAM Filter] )

Using "IN"

All comments

cbridges

Try this:

IIF([ServiceLine] = "Tax" 
AND 
([Sector] = "Life Sciences" OR "Professional Firms & Services" OR "RE, Hospitality & Construction")
AND 
[FSO WAM Filter] = "Other")
THEN "UK Additions - Tax"
ELSE [FSO WAM Filter] 
ENDIF

JohnJPS

Hello Jon!

Would something like this work:

IIF ([ServiceLine] = "Tax" 
AND 
([Sector] IN ("Life Sciences","Professional Firms & Services","RE, Hospitality & Construction"))
AND 
[FSO WAM Filter] = "Other" , "UK Additions - Tax" , [FSO WAM Filter] )

Using "IN"

MarqueeCrew

Sector in ("a", "B")

That's a hint

cbridges

If that doesn't work, you may need to repeat your OR statements like this (not 100% sure on this):

IIF([ServiceLine] = "Tax"
AND
([Sector] = "Life Sciences" OR
[Sector] ="Professional Firms & Services" OR
[Sector] ="RE, Hospitality & Construction")
AND
[FSO WAM Filter] = "Other")
THEN "UK Additions - Tax"
ELSE [FSO WAM Filter]
ENDIF

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703