how to count all excepted duplicated values in a selection

Sat, 29 Dec 2012 18:18:39 GMT

Hi all,

I have a simple selection with 5 calls and ref. call (unique) :

If I count total of Number = 5

If I count distinct of Number = 3

My question is how to count all (Number) excepted duplicated values (here 1 with 559900...) in a selection to get only 2 answers and not 3 ?

if you say (Total - Distinct)=2 works here but doesn't work with :

If I count total of Number = 5

If I count distinct of Number = 2

and 5-2 is wrong because the all excepted duplicated is 1

Thank's a lot for any idea !

Sebastien

Re: how to count all excepted duplicated values in a selection

Gysbert_Wassenaar — Sat, 29 Dec 2012 20:04:51 GMT

Try count({<Number={"=count(Number)=1"}>} Number)

Sat, 29 Dec 2012 20:49:38 GMT

Thank's Gysbert,

you are right, it work's !