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.
Filtering a view on a formula field?
+1
+31Interesting! 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
+1Interesting! 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
I created a copy with cleansed data. What do you suggest as the best method share the example base?
+31I 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
+1You could create an invite link to it and send it to me via the forum's private message system
Message sent with link. Thanks
+31Message 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.