AnsweredAssumed Answered

Counting only unique values.

Question asked by jamie.hunt on Dec 1, 2009
Latest reply on Apr 14, 2010 by imgaryshap

Title

Counting only unique values.

Post

I hope someone can help me here, I'm sure there is an easy way to do this. I am looking to set up a calculation to only count unique values...

 

 

For example if I have 5 records with the following ID's:

 

ID1, ID2, ID2, ID3, ID4, ...the count will return 4 only counting each unique value.

 

 

 

 

And if I have 10 records say with the ID's: 

 

ID1, ID2, ID2, ID3, ID4, ID5, ID6, ID7, ID8, ID8   ...the count will return 8 counting only each unique value 

 

 

 

I hope someone can help me this this,

 

Many thanks. 

Outcomes