I'm trying to create a calculated field to find the exact match of the values as below
THEN [emp ID] ELSE NULL end
but the above formula is returning true for "HA@xyz.com" which is the email id of some other person. this is returning true because its available in string "STEVE_CUNHA@xyz.com"
Could anyone please help me in making the above formula look for exact match of the email ids?
you can simply write:
if [Emai2]="JOSHUA_RODRIGUEZ2@xyz.com" or [Emai2]="JOHN_MULLER1@xyz.com" or [Emai2]= "CHRIS_SALVATORE@xyz.com" or [Emai2]="STEVE_CUNHA@xyz.com"
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...