Data filtering

[Feras95p]

Dear all,

I want your help in that, I want to filter some specific output column so I want to use the function (if it is not null x column and y column and z column then True else if F how can I do that? Any help?

[BrandonB · Accepted solution]

!IsNull([XColumn]) AND !IsNull([YColumn]) AND !IsNull([ZColumn])

If you put this in the custom filter it will only pass through records if the x, y, and z columns ALL contain values in them. 

IsNull() is the main function that checks if a value is null. The exclamation mark means NOT, so by saying !IsNull(), you are saying only pass the values through if they are not null. Let me know if this helps!

[Htaneja2]

Please check the solution,

the file contains two simple ways of doing it,

1. by making a new column for true/false

2. by simply using the filter tool

If you find the solution helpful, please mark it as a correct solution. 🙂