Formula
[OpenInputValueBlock]
IF (@ISLEV("Employee", 0))
IF ("Salary Basis" == [SalaryBasis.Annual])
IF("Grade" == 1)"Target Rate" = 80000;
ELSEIF("Grade" == 2)"Target Rate" = 90000;
ELSEIF("Grade" == 3)"Target Rate" = 100000;
ELSEIF("Grade" == 4)"Target Rate" = 110000;
ELSEIF("Grade" == 5)"Target Rate" = 120000;
ELSEIF("Grade" == 6)"Target Rate" = 130000;
ELSEIF("Grade" == 7)"Target Rate" = 140000;
ELSEIF("Grade" == 8)"Target Rate" = 150000;
ELSEIF("Grade" == 9)"Target Rate" = 160000;
ELSEIF("Grade" == 10)"Target Rate" = 170000;
ELSEIF("Grade" == 11)"Target Rate" = 180000;
ELSEIF("Grade" == 12)"Target Rate" = 190000;
ELSEIF("Grade" == 13)"Target Rate" = 200000;
ELSE"Target Rate" = #MISSING;
ENDIF
ELSEIF ("Salary Basis" == [SalaryBasis.Hourly])"Target Rate";
ENDIF
ENDIF
[CloseInputValueBlock]
Description
Calculates the predefined Target Rate based on employee grade.