Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
How about this
Count({<FieldName = {"=Count(FieldName) = 1"}>} FieldName)
Thank you so much. I do have a question though...
I do get all negative results. 😉 (I don't understand that...)
How about this
Count({<FieldName = {"=Count(FieldName) = 1"}>} FieldName)
Thanks guys. Highly appreciate your solutions! Keep up the good work!