Multi Column Formula
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.