OR filter is not working, cant figure it out///
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Dan5
8 - Asteroid
‎12-17-2021
12:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a fairly simple custom filter:
[Opportunity] > [Min_deal_size] or [ARR]>0 or [Pipeline] >0
However the output still contains records that match this next filter:
[Pipeline] = 0 && [ARR] = 0 && [Opportunity] < 10000
10000 is the value of my Min_deal_size fyi.
I am pulling my hair out...thanks!
Labels:
- Labels:
- Help
2 REPLIES 2
binuacs
21 - Polaris
‎12-17-2021
02:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Dan5 can you provide some sample data to verify ?
Qiu
21 - Polaris
‎12-17-2021
10:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Dan5
Better to have some sample data.
Since you are use OR, given your data nature, it may end up the results looling like a different filter.