Health Care Costs

Formula

[OpenInputValueBlock]

IF (NOT @ISUDA([Dimension("DIM_NAME_SCENARIO")], "ACTUAL"))

IF (("Salary"<> #MISSING) AND ("Employee Type" == [EmployeeType.Regular]))

IF("BegBalance"->"Health Plan" == [HealthPlan.IndividualPlan])

100;

ELSEIF("BegBalance"->"Health Plan" == [HealthPlan.IndividualPlus1])

175;

ELSEIF("BegBalance"->"Health Plan" == [HealthPlan.FamilyPlan])

300;

ELSE

#MISSING;

ENDIF

ELSE

#MISSING;

ENDIF

ENDIF

[CloseInputValueBlock]

Description

Calculates health care costs based on selected health plan.