Using "!=blank()" is not returning the correct result

[Michael_Jenson]

[Eric_Petersen]

I was having similar difficulty using the BLANK() function. I was reading these community posts for help.

This simple filter shows the records where the Project Value (currency field) is empty works as expected.

I assumed the following formula would work in field and present the same results:

It did not, hence the name of the field, Project Value Blank or $0.00 as it returns 1 for $0.00 as well as empty fields.

Somehow, when I use this formula:

NOT({PROJECT VALUE}!=BLANK())

It only returns the empty or blank records as desired. Anyone want to explain this logic?

Hopefully, using the NOT() function will help others here with their use cases.

[Tuur]

@Eric_Petersen: check Blank() & Zero problem or the link a couple of posts higher: Using "!=blank()" is not returning the correct result :winking_face:

[Eric_Petersen]

Try:
not(field != blank())
I am curious you have a working solution @Tuur now.

[Tuur]

Sure. As explained it the posts above. :slightly_smiling_face:

It still is an Airtable bug though.