7 Replies Latest reply: Aug 22, 2012 3:56 AM by Göran Hofstedt RSS

    Exclude duplicates

    Göran Hofstedt

      Hi

      I have to fields, NumberofChildren and ID.

      Because the ID occurs multiple times the sum(numberofchildren) shows wrong. I want to distinct them so it only sum it ones.

      And, does that don´t have a children are marked as 0.

      How can I do that?