Rec. Bonus %

Formula

[OpenInputValueBlock]

IF ("Grade"<= 2)"Rec. Bonus %" = 0.10;

ELSEIF ("Grade"<= 4)"Rec. Bonus %" = 0.15;

ELSE"Rec. Bonus %" = 0.20;

ENDIF

IF ("Employee Type" == [EmployeeType.Regular])

IF ("BegBalance"->"Performance" == [Performance.FailsToMeetExpectations])

0;

ELSEIF ("BegBalance"->"Performance" == [Performance.NeedsImprovement])"Rec. Bonus %" * 0.50;

ELSEIF ("BegBalance"->"Performance" == [Performance.MeetsExpectations])"Rec. Bonus %";

ELSEIF ("BegBalance"->"Performance" == [Performance.ExceedsExpectations])"Rec. Bonus %" * 1.1;

ELSEIF ("BegBalance"->"Performance" == [Performance.FarExceedsExpectations])"Rec. Bonus %" * 1.25;

ELSE

#MISSING;

ENDIF

ELSE

#MISSING;

ENDIF

[CloseInputValueBlock]

Description

Calculates a predefined bonus percentage based on performance.