4 Replies Latest reply: May 28, 2014 9:29 AM by Stuart Frew RSS

    Count distinct duplicating figures

    Stuart Frew

      Hi,

       

      I have 2 data sets that are hooked together by Staff_Name.

       

      distinct(Staff_Name) is counting exactly double the number of staff.

       

      What is the reason for the double count as the data model is hooked together on the Staff_Name?

       

      thanks

      Stuart