Ends With 1

[Ox73]

Hi does anybody know if there is a formula that can be created to only display the value of a field that ends in a particular character for example:

If I have a list of numbers.

51234
22366
39385
69875
51864
59857

To only display all the fields that contain information that ends with 5 for example so my results should only show these two numbers:

39385
69875

And suppress all others?

 

[kutoose]

Use Right(Totext({Table.Field},0),1) to get the last digit of the number.

Use this condition to suppress ie
Right(Totext({Table.Field},0),1) <> "5"

 

[vidru]

Are these actual number fields or strings?

I like to use the Mod functions for Number fields. In your case, a suppression formula using Mod would look like:

{Table.Field} Mod 10 <> 5

-dave