Sum(Distinct Value) Trying to get the sum of?

I've got a dataset that gives me an employee count and an employee count target by location.

When I view this by location it gives me the correct values with the target value coming from the following Beastmode:

 

SUM(DISTINCT `Target`)

 

The employee count comes from this Beastmode:

 

COUNT(DISTINCT `WRISEmployeeID`)

 

When I want to see this rolled up into a market however the employee count seems to roll up fine, but the Target value is rolling up to a value of 35 which appears to be the number of entries and not the sum value of the Beastmode, it should be more along the lines of 129.

I've tried a couple of methods using Case Statements etc but to no avail.

Any ideas?

Thanks

Randy

Comments