Re: Filtering a view on a formula field?

7474 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

My filer is not working as expected.  I am filtering on formula field.

The goal is to hide paid charges and only show unpaid charges.  My filter is filtering on NOT = $0.00.  Showing pictures of file, results and the formula for the field.

5 Replies 5
18 - Pluto
18 - Pluto

Interesting! Any chance you could share an example base where this is happening or some screenshots of your data?  I wasn't able to replicate this and am very curious about it too

Screen Recording 2023-03-10 at 8.27.25 PM.gif

I created a copy with cleansed data.  What do you suggest as the best method share the example base?

You could create an invite link to it and send it to me via the forum's private message system

Message sent with link.  Thanks

After exploring this, we discovered this was happening as the field was formatted to display as "Currency", which automatically truncated everything after two decimals, and as a result what displayed as 0 wasn't actually 0, but stuff like 0.0001 instead, causing them to display despite the filter!