Tasked with trying to create a report where if the last digit is a 1-9. it shows up in the report. Anything with a 0 is good information and doesn't need to be shown.
1-9 means it was entered wrong and has to be checked (this happens often)
Cannot seem to find a way to create a filter expression to do that. Just an example, anything highlighted is what I need to show.
I did notice that I cannot just filter "contains" - says that is an incompatible operator. I've tried a few different column types, (it was precise decimal, i changed to decimal, text, and numeric)
It is a live data source.
