This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a very simple business process involving filtering multiple field in order. 1 input data set, filter involving many categories.
Problem is some of the rules involves multiple fields and conditions, the results I'm getting is not as expected.
[LOB] = "FDR"AND [Job_Category ] !="BUS SUPPORT"AND [Job_Name] = "Director"
results under True showing "Director" for all of [LOB] not just FDR .
I want to use a formula tool but I'm not sure how it works in relation to filter. Thanks,
Do you have a sample of the data you are using?