Power Platform Community Forum Thread Details

I am trying to determine the percentage when employees report overtime in a given week. In my percentage control I have this formula:

// Need to check to see if the Total hours in a workweek is more then 40 hours, if true, then OT performed on
// Mon or Tue or Wed or Thu or Fri or Sat needs to be charged at 150 - OT performed on Sun or Holiday needs to
// charged at 200%

The problem I am having is that the Percentage is not being returned by the formula below. I have no idea what I am doing wrong here.

If(LabelTotalHours > 40,
Text(
DataCardValueOTEdit.SelectedDate,
"ddd"
) = "Sun",
200,
If(
LookUp(
OREHolidays,
DateHoliday = DataCardValueOTEdit.SelectedDate,
true
),
200,
150
)
)

In my Label Control named LabelTotalHours I keep a running total of all hours for a given workweek.

This is the formula used in that label control:

With(
{
wList:
Filter(
'OREPayrollOvertime',
Week=GalleryBrowseOvertime.Selected.Week &&
EmpID=GalleryOTResManagers.Selected.ID
)
},
Sum(
wList,
OvertimeHours
) + 38
)