Multi Column Formula

[btkenney603]

Hello, 

I'm having trouble filtering out 2 integers in separate columns with the filter tool. My expression below is what i have come up with. Does anyone know why this would not work?  

Thanks

 [ACCOUNT]=50550 AND [SUBACCOUNT]=10 

[AngelosPachis]

Hi @btkenney603 ,

If you have no records falling out of the "T" anchor of your filter tool, then that means that there are no records that have simultaneously the values 50550 for ACCOUNT and 10 for SUBACCOUNT.

If you want to filter out all records that either have 50550 for ACCOUNT or 10 for SUBACCOUNT, you can amend your expression to 

[ACCOUNT]=50550 OR [SUBACCOUNT]=10 

[echuong1]

Your expression should work. The only thing I can think of that would cause an issue is if your datatypes are mis-matched. You can use tostring() to convert everything to strings and have the accounts and subaccounts in quotation marks.

If you want to have each separate, use an or instead of and.