how to count all excepted duplicated values in a selection

[#1]

Hi all,

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

Number	Reference_Call
385444588	50b9d5daLyon1e0758d6
559900523	50ba0751Boul1e0d3da7
559900523	50ba0787Lyon2e031322
559900523	50bb41a9Lyon2e0147cc
695515128	50b9bf5fLyon2e0b191f

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 :

Number	Reference_Call
559900523	50b9d5daLyon1e0758d6
559900523	50ba0751Boul1e0d3da7
559900523	50ba0787Lyon2e031322
559900523	50bb41a9Lyon2e0147cc
695515128	50b9bf5fLyon2e0b191f

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

[Gysbert_Wassenaar · Accepted solution]

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

[#3]

Thank's Gysbert,

you are right, it work's !