Formula
[OpenInputValueBlock] IF ("Salary Basis" == [SalaryBasis.Annual] OR "Salary Basis" == #MISSING OR "Hours per week"<= 40) #MISSING; ELSEIF ("Salary Basis" == [SalaryBasis.Hourly]) IF ("Pay Type" == [PayType.Exempt] OR "Pay Type" == #MISSING) #MISSING; ELSEIF ("Pay Type" == [PayType.NonExempt] AND "Hours per week"> 40) ("Hours per week" - 40) * "Salary Rate" * 52; ENDIF ENDIF [CloseInputValueBlock]
Description
Calculates the annual overtime for hourly employees.