Annual Overtime

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.