use single select field values in input select

[Frank472389]

I have a select drop down  field with number rating from 1 to 10,  1 - 2 - 3 - 4 .. etc...  .   I want to filter all the records that have a rating bigger than, let's say 6, but there's no number operators (">", "<") for the select field.

Is there a solution to this?

thank you in advance.

[TheTimeSavingCo · Accepted solution]

Try creating a formula field to extract the numerical value of the select field, and then filter off of that:

VALUE(Select)

[Frank472389]

Thank you!

[Frank472389]

I tried TheTimeSavingC solution and it works perfectly. My select field is called "Rating",  I created a formula field called "Rating Formula" and wrote in the expression box "VALUE(Rating)". The function "VALUE" is needed to convert it to a number.  When I select the drop down from one field, it changes the other accordingly.

Then I added a filter to "Rating Formula" using the math operator ">" and it filters correctly.    Finally, I hid the formula field from view because I don't need to see it.