In a filter, compare if one field is 'greater than/less than' another field

[snolan]

I've created a Database View that joins a couple tables.   In the resulting list, I want to be able to filter if one field is less than another field.   All the operators except "is same" & "is different" require a numeric value.   Anyone have any idea how I can accomplish this.   I thought this would be fairly easy but it isn't working out that way.

[marcguy]

What are the field types? I believe they both need to be integer values to have the 'greater than, less than' filter option.

[snolan · Accepted solution]

Both fields are Integers.   I did find a way to do accomplish what I needed although it wasn't using the list filters.   I created a Business Rule using Before/Query for my Database View record and was able to add logic that way.