8 Replies Latest reply: Jun 16, 2016 3:27 AM by Hendriks Steffens RSS

    Count duplicates and calculate with them

    Hendriks Steffens

      Hi,

       

      I have a table which consists of the following data, for example:

       

      Item NoAttribute AAttribute BCounted duplicates
      1234wa0,25
      1234xb0,25
      1234yc0,25
      1234zd0,25
      2345fe1
      3456gt0,33
      3456hn0,33
      3456im0,33

      ...

       

       

      I need to create that last column. To do that I need something like:

       

      1 / (how many times does an Item No exist in the table)

       

      My approaches until now are:

       

      1/count([Item No])

      1/count(if([Item No]=[Item No], [Item No]))

      1/(count(distinct [Item No])/count([Item No]))

      (count(distinct [Item No])/count([Item No]))

       

      But none of them produces the results I need.

       

      Any help would be greatly appreciated.