2 Replies Latest reply on Jul 25, 2018 9:11 PM by Wendy Weber

    LOD calculation not providing a unique count

    Wendy Weber

      I am noticing that the Dcount function isn't working correctly while calculating the role "Manager".  The attached dashboard shows 6 Unique Employee ID's for Adds and 3 Employee ID's for Terms but it should be 3 Adds and 1 Term for of a difference of 2.  The adds is IDs:13,24,49 and the Term ID is 66.  Please help!

       

       

      IndustryRoleTypeStateEmployee ID
      Real EstateManagerAddVA13
      Real EstateManagerAddNC13
      EnergyManagerAddNY24
      EducationManagerAddOH49
      Real EstateManagerAddOH49
      ITManagerAddOH49
      Real EstateManagerTermsIL66
      EnergyManagerTermsIL66
      RegionalManagerTermsIL66