Count Distinct Project ID

[#1]

Hello all,

I can't seem to get this query to work properly.

Here is what I want to do:

Exclude certain project status

Count Distinct Project IDs within the Project Details Table

count(
{<
[Project Status]-={'Project AWARDED', 'COMPLETED', 'Project CANCELLED', 'ON HOLD'}
>}
DISTINCT
[Project Details.Project ID]

As always any help is greatly appreciated.

Regards,

Myles

[its_anandrjs · Accepted solution]

Hi,

Your expression is correct if you want to exclude all this 'Project AWARDED', 'COMPLETED', 'Project CANCELLED', 'ON HOLD' status

count( DISTINCT
{<
[Project Status]-={'Project AWARDED', 'COMPLETED', 'Project CANCELLED', 'ON HOLD'}
>}

[Project Details.Project ID] )

Regards

Anand

[#3]

Hi Anand,

This worked great! Thank you!

Regards,

Myles

[its_anandrjs]

Thanks it works for you please close the thread by appropriate answer.

Regards

Anand