Formula
[OpenInputValueBlock]
IF ("Cal TP-Index" == 1 AND "BegBalance"->"Merit Month"<= [Month.Jan]) "BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 2 AND "BegBalance"->"Merit Month"<= [Month.Feb]) "BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 3 AND "BegBalance"->"Merit Month"<= [Month.Mar]) "BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 4 AND "BegBalance"->"Merit Month"<= [Month.Apr]) "BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 5 AND "BegBalance"->"Merit Month"<= [Month.May]) "BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 6 AND "BegBalance"->"Merit Month"<= [Month.Jun])"BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 7 AND "BegBalance"->"Merit Month"<= [Month.Jul]) "BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 8 AND "BegBalance"->"Merit Month"<= [Month.Aug])"BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 9 AND "BegBalance"->"Merit Month"<= [Month.Sep])"BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 10 AND "BegBalance"->"Merit Month"<= [Month.Oct])"BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 11 AND "BegBalance"->"Merit Month"<= [Month.Nov])"BegBalance"->"Merit Adjustment %";
ELSEIF ("Cal TP-Index" == 12 AND "BegBalance"->"Merit Month"<= [Month.Dec])"BegBalance"->"Merit Adjustment %";
ENDIF
[CloseInputValueBlock]
Description
Calculates the cumulative merit adjustment percentages. Use for calculating merit.