Count Unique (not distinct) - so count the numer of non-doubles

[MrBosch]

Hi

I am thinking about a solution for this one:

I have a great number of variables in a column. Let's say

ONE
ONE
ONE
TWO
THREE
THREE

What I need to count are the UNIQUE (single) variables. So COUNT DISTINCT would result in 3, COUNT gives me 6 but I want 1 as an answer since that is the only value that has an single occurence (="TWO").

Anyone you has an idea?

Thanks!

[Vegar · Accepted solution]

You could try something like this.

Sum(AGGR( Count(YourField)=1, YourField))

[MrBosch]

Thank you so much. I do have a question though...

I do get all negative results. 😉   (I don't understand that...)

[sunny_talwar · Accepted solution]

How about this

Count({<FieldName = {"=Count(FieldName) = 1"}>} FieldName)

[Vegar · Accepted solution]

That's true
Count(YourField)=1 will return -1 if True
Just as a minus before the sum to get positive values.
-Sum(AGGR( Count(YourField)=1, YourField))

[MrBosch]

Thanks guys. Highly appreciate your solutions! Keep up the good work!