Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have written a post about this question recently, but I am currently stuck once more. I can't understand how set analysis works in this case, because despite having inserted into the measure what I am looking for and having told the measure to use the set analysis over each function that needs it, the results do not match.
See screenshots below, when I don't select any employee, the measure 'Team Measure' works fine:
However, when I select an employee, the measure suddenly turns to the same output as the employee selected:
This is the measure I am currently using:
// All Other Employees Measure
Sum(
Aggr(
{< Employee= >} // Ignore selection of Employee
Count({< ACTION_CODE = {'LABOR_OFF'} >} distinct MainSFC) * Time_Product,
MainSFC, Employee
)
)
/
(
Sum(
Aggr(
{< Employee= >} // Ignore selection of Employee
Count(distinct WorkingDay) * 7.5 * 60,
Employee
)
)
-
Sum(Absence) * 60
)
Can someone please help me figure out what I am doing wrong?
in the denominator you need to use the total
for example:
count(employee) / count(total {<employee=>}employee)