Forum Discussion
Help required diving individual hours by total billable hours.
Hi All, Refer below screen shot : I want to divide hours/Amount : 156 with billable hours(measure) 160.50 and expecting client utilization has .971 and similarly 4/160.50 and expecting .028, but ri...
Can you test your variable, to see what it returns.
In the formula after RETURN replace the divide function and all its argument, by the name of the variable you want to test.
Check if CurrentEmployeeH and TotalHours are giving expected result.
RETURN
CurrentEmployeeHthen same with Totalhours. Let us know
AilleryO
Memorable Member
Memorable MemberMake the change just on the 1st VAR, not on the line 3
I am getting zero.
% by Employee =
VAR CurrEmployee = SELECTEDVALUE(Utilization[Employee])
VAR CurrentEmployeeH = CALCULATE( SUM(Utilization[Hours/Amount]) , (Utilization[Employee]) = CurrEmployee, ALL (Utilization[client names] ) )
VAR TotalHours = CALCULATE( SUM(Utilization[Hours/Amount]) , ALL ( ) )
RETURN
DIVIDE ( CurrentEmployeeH , TotalHours )
- AilleryO
Can you test your variable, to see what it returns.
In the formula after RETURN replace the divide function and all its argument, by the name of the variable you want to test.
Check if CurrentEmployeeH and TotalHours are giving expected result.
RETURN
CurrentEmployeeHthen same with Totalhours. Let us know