[SalesForce] Report Accounts without open activities

I'm building a report to show all accounts without open activities.
It's:

  • Accounts with or without related records from Activities

  • with filter activity status equals Completed.

enter image description here

I don't understand. In the report there are also accounts with activity with status not equals to completed.
Do you Know why?

UPDATE TO THE QUESTION:

Now it works and i want that each account appears just one time in the report(See in the picture Grand Hotel..).
This account hasn't open activities but it has 2 closed activities.

Do you Know how archive this?

enter image description here

Thanks in adavantage for any advice.

Best Answer

You can do this with the new Cross Filter feature, described here and here's a short demo.

The report would start with the standard Accounts report, then you'd add a cross filter for "without Activities", and even further define filters on the Activity object.

It will look like this when you're done:

enter image description here

Related Topic