Set Analysis not returning the desired results

[wcoleman0908]

I've been unsuccessful in getting this stuburn code to work correctly. What I'm attempting is to return is all records where:

1) The [project status] is open

2) Return those projects where NO projects have any values with a  [completion status] equal to 'In_Prog'

The problem is that it returns projects but includes those projects with 'In_Prog' data values. My task is to Complete those projects that are open that are no longer 'In_Prog'

My set Analysis is as follows:

Count(aggr(Count({<[Project Status]={'Open'},[Completion Status]-= {'In Progress'}   > }distinct [Projects]), [Projects))

I included a sample data file for testing, Any insights would be great

[coleturegroup · Accepted solution]

=count(Aggr(Only({$<[Project Status]={'Open'}, [Projects] = E({<[Completion Status]={'In Progress'}>} [Projects])>} Group, [Completion Status]), [Completion Status]))

Thanks but unfortunately it didn't work as desired. Maybe i need to add more detail to show my results.

I included the updated QVF file, the table below show only show the following results:

Group C should only show project 7300, 8728

Group E should only show project 9035, 9163

Group F should only show project 6753, 8605

The Aggr seems to not be formed properly, can you see the issue?

Thanks in advance for all your help