Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Overtime calculation

I am trying to calculate weekly over time of total Duration. The formula(s) that I am currently using are: TotalHours = SUM(HoursData[Duration]) Overtime = IF([TotalHours] > 37.5, IF(([TotalHo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Its still not calculating on the row level of the matrix .. 

 

Padycosmos's avatar
Padycosmos
Solution Sage
3 years ago

Hope this edited one helps:

Overtime =SWITCH(TRUE(),[TotalHours]-37.5>6.5, 6.5,[TotalHours]-37.5)<=6.5, [TotalHours]-37.5<=0,0)