Accurate count of data

[Anonymous]

Greetings,

  I am having an issue with a data set that I have to get my KPI to reflect the accurate number I need to show.  So, I have a list of people that have multiple start dates to classes and also an indicator if they are a project member or not.  When I try to calculate from the list of 64 people, it is counting the same people who show up more than once on the list rather than each person individually.  No matter if I count it or sum it up, I should only show 57 people and it keeps kicking back those 64 entries.  Any help would be appreciated.  Thank you.

[Gui_Approbato]

Hello,

Use the DISTINCT word to remove duplicate entries.

Example:

Instead of Count( Name) use Count(Distinct Name).

[Anonymous]

I tried that, but I also have to count up of those distinct people who are project members as well.  That is where I am getting stuck.