Forum Discussion
Anonymous
7 years agoNot applicable
Cannot apply operator & to types Logical and Text
Hi folks,
I have obviously been staring at this for too long and am too tired, so can I please ask for your assistance to identify why I'm getting the "we cannot apply operator & to types Logical and Text" to the following formula:
if Text.Contains([Location_Name],"WP") = true & Text.Clean([Job_Title]) = "Associate" then "Associate" else if Text.Contains([Location_Name],"WP") = true & Text.Clean([Job_Title]) = "Process Control" & Text.Contains([Union],"AU") then "Process Controller" else if Text.Contains([Location_Name],"WP") = true & Text.Clean([Job_Title]) = "Process Control" & Text.Contains([Union],"CF") then "Power Station Controller" else [Job_Title]
Thanks in advance.
OF
'&' is concatenate, I think you need 'and'