We have a custom object named Contract Calendar where the sales users put information in about Contracts for Internal Contracts aswell as tracking competitor contracts (we are using a field named current supplier for tracking internal vs Competitors)
I am trying to run a report that shows All Accounts that do not have an Internal Contract. i have applied a filter on the Current Supplier lookup field yet it still shows those contracts in the report just with a blank value
am i doing something wrong ? hoping someone can help .
6 件の回答
Have you tried using an Accounts Report with a "without" Filter?
Documentation Example: Use WITHOUT in Cross Filters
https://help.salesforce.com/articleView?id=reports_cross_filters_without.htm&type=5 (https://help.salesforce.com/articleView?id=reports_cross_filters_without.htm&type=5)