Forum Discussion
Filtering on flag fields
I have a column called (Flag Deleted). It is data type true/false and contains 3 unique values True, False and Blank. Using this column as a field to filter on does weird things. When selecting false...
I think its because of the way the equality operator works. 0 = BLANK() and FALSE() = BLANK() both return true. You could try replacing blanks with -1, that would let you filter for either 1, 0 or -1
I did not know about the them being equal to eachother. However, if you select BLANK() in the filter, you do only get the blank values, not the false ones. It's only the case other way around.