CASE WHEN using IN
I am trying to filter my records by specific accounts. I am using beat mode to try and do the following:
CASE WHEN `Company Name` IN('COGNIZANT', 'AARP') THEN 1 ELSE 0 END
Then I use this as a filter set to 1 hoping to only return the accounts I am looking for.
When I run this I never get any accounts returned.
Any input would be greatly appreciated