1 Reply Latest reply on Nov 23, 2018 4:26 AM by Ankit Bansal

    Function for searching exact match of value

    Gaytri k

      hi Team,


      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?