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 am trying to filter PTC,REFD and blanks in the data set attached. However, when using [Business]IN("PTC","REFD","") the filter is not picking up the blanks it only picks up PTC and REFD. Is there an alternative way to pick up the blanks in the business column?
Thank you, however the trying the below still doesn't pick up the empty cells in the Business column. Attached is the excel with the data if, the output I'm trying to achieve is in the correct output Tab.
The filter I am currently inputting is: [Type ] = "Ext" AND [Admin]IN("Peter","Joe ") AND [Business ]IN("PTC","REFD") OR ISEMPTY([Business]) AND [Amount ] != 0
There's a few things you need to do here, firstly i've amended your filter condition to include brackets around the [Business ]IN("PTC","REFD") OR IsNull([Business ]) section. Otherwise Alteryx will treat the first condition as seperate to the second, with the brackets Alteryx will look for one of those two conditions as the "AND" statement.
[Type ] = "Ext" AND
([Business ]IN("PTC","REFD") OR IsNull([Business ])) AND
[Amount ] != 0
Secondly, i've used a data cleansing tool to convert null values in your [Amount] field to be zero, which will allow your last condition to be satisfied (Amount != 0).
Thirdly, i've removed leading and trailing spaces in string fields (again with the data cleansing tool) to avoid any mis-matches.
I've attached my workflow for you to download if needed.