(Help! I need somebody HELP!) Count expression doesn't read accurate when using Set Analysis

[#1]

I'm trying to count distinct Account_Id's visited by each salesperson.

To do that accuratelly the Count statement should only evaluate the set where the total calls by salesperson are greater than 0, which is not doing and I can't figure why.

Take an example on the qvw attached:

The Contact Owner (CO) "Beatriz Aquino" Visited Entities should read 112 instead of 146 and Targeted Entities should read 129 instead of 150.

As far as I understand the problem is in the set analysis statement which is selecting distinct accounts where the CO have either a call or a target even if that call was made by another CO.

Looking forward for your help

Thanks

[#2 · Accepted solution]

Hello,

I think I made it...

Please see the file attached. I just modified the set analysis formula.

Steve