Forum Discussion
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...
Really sorry, there was an extra bracket. I have removed it now. Please try again
Overtime =SWITCH(TRUE(),[TotalHours]-37.5>6.5, 6.5,[TotalHours]-37.5<=6.5,[TotalHours]-37.5, [TotalHours]-37.5<=0,0)
It still didnt work - I am trying to share the dataset but couldnt find the option to do so. I am sorry
You can put it in google drive and paste the link here