How to set valid if rule based on another field

I’m trying to run the following Valid IF but I’m getting the error below:

If the type field is ROUTE COMPLETE, then the Fuel Cost field is valid if its >0 but less than 1000. The field could otherwise be 0 or >0 but less than 1000.

0 8 187
8 REPLIES 8
Top Labels in this Space