Filtering a view on a formula field?

[Lforino]

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.

[TheTimeSavingCo]

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

 

[Lforino]

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

[TheTimeSavingCo]

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

[Lforino]

Message sent with link.  Thanks

[TheTimeSavingCo]

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!