Unable to compare two numerical fields

[JustAnotherStud]

i have two fields that are numerical fields.  when I try a search that says:

index="test" AND field1 > field2

i get no results when I know that shouldn't be the case.  Any help would be greatly appreciated.

thanks

-JustAnotherStudent

[JustAnotherStud]

Thank you for the assistance 

[ITWhisperer · Accepted solution]

index="test" | where field1 > field2