2 Replies Latest reply: Dec 29, 2012 3:49 PM by Sebastien Parmentier RSS

    how to count all excepted duplicated values in a selection

      Hi all,

       

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

       

      NumberReference_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 :

       

      NumberReference_Call
      55990052350b9d5daLyon1e0758d6
      55990052350ba0751Boul1e0d3da7
      55990052350ba0787Lyon2e031322
      55990052350bb41a9Lyon2e0147cc
      69551512850b9bf5fLyon2e0b191f

       

      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