3 Replies Latest reply: Dec 8, 2014 3:20 PM by Anand Chouhan RSS

    Count Distinct Project ID

    Myles Holland

      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