Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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