I have an issue I'm trying to sort out. I have created a calculated field which is working correctly and it takes into account the wording of the lead source and alocates the leads accordingly. For example, the statement is
IF CONTAINS([Lead Source],"PARTNER DEMAND CENTER") THEN "PARTNER"
However, it is possible the lead source to be named "LEAD SOURCE PARTNER DEMAND CENTER" and in this case I don't want to be counted in Partner. Is there any way I could put an exception in the statement so as to take into account stricly only the leads coming from PARTNER DEMAND CENTER, excluding other wording ?