This particular task of comparing the [Gross Revenue] field to $100,000,000 seems straight forward, but in JRiver land, it is kinda weird and complex. Let me break it down for you:
First, you need to go into the Customize View dialog for your view and use the Set Rules For File Display dialog. In Set Rules for File Display, you would normally use the drop down lists to choose a field and then choose what to compare to. But if you select Gross Revenue, you'll see that it only contains comparisons like "is" and "contains". That's because [Gross Revenue] is a STRING type field! Which makes this job much less fun. But we can still do it.
It means we need a custom expression to manipulate the data into a form that we can use. So you'll want to use the "import/export" button at the bottom left of the Set Rules For File Display dialog. This will allow you to enter your custom expression more easily without MC trying to do any formatting for you.
First, we need to make [Gross Revenue] of a format that we can use for numerical comparisons. Namely it needs to be only numbers. So let's remove the "$" and "," characters:
removecharacters([gross revenue],$/,,0)
Notice the "/" before the "," in the 2nd field. Comma is a special character for MC, so I had to 'escape' it by putting a "/" in front of it. It's already weird right? That's ok, let's move on.
So this leaves us with a bare numerical field which we can use for comparison. Let's add that comparison:
[compare(removecharacters([gross revenue],$/,,0),>,100000000)]
This is comparing our bare value to 100,000,000 and seeing if it is greater than (>). Great! We're almost there. Now it gets really weird. I could explain this if you'd like, but for just a moment take this syntax on faith. Any time you need to do a custom field like this, that does a test, you need to add this around it:
[=MC_Expression_Here]=1
Kinda weird, but not too bad. So our final custom expression becomes:
[=compare(removecharacters([gross revenue],$/,,0),>,10000000)]=1
Cut and paste that into your import/export box and save it. It should now work as you expect.
Brian.