I'm trying to filter out all records with a value over 12 Billion. In the input file, I've converted all of the values to make sure they're numeric. Then, I even added a select tool into the workflow right before the filter to remove all values over 12 billion to ensure that the field I'm trying to filter is still numeric. I changed it from v_string to fixed decimal. Now I want to filter out any value over 12 billion. I tried the filter function and constructed a function that reads [CompanyMarketCap] < "12,000,000,000". I'm now getting a message that "<" is an invalid operator. I'm wondering if I need to try something totally different.
Any help is most appreciated!
Solved! Go to Solution.
Looks like I posted too soon. I think I got it. I removed commas from my original data, changed the field from v-string to fixed decimal and input the filter again without the commas, and it now seems to work. :)