
1. Re: Help with a Fixed LOD Calculation
Deepak Rai Jan 14, 2020 11:48 AM (in response to Allan Merrell)1 of 1 people found this helpfulYes, Here it is:
You need these Calcs to be There:
Calculation2:
If [Relationship]="Enrollee" Then 0
elseif
[Relationship]="Husband" Then 1
elseif
[Relationship]="Wife" Then 2
elseif
[Relationship]="Son" Then 3
else 4 end
Final Calc:
IF
{FIXED [Enrollee ID]:SUM([Calculation2])}]=7
THEN "Enrollee+Dependents"
elseif
({FIXED [Enrollee ID]:SUM([Calculation2])}]=5 OR
{FIXED [Enrollee ID]:SUM([Calculation2])}]=9)
THEN "Family"
elseif
({FIXED [Enrollee ID]:SUM([Calculation2])}]=4 OR
{FIXED [Enrollee ID]:SUM([Calculation2])}]=3) THEN "Enrollee+Dependent"
elseif
({FIXED [Enrollee ID]:SUM([Calculation2])}]=1 OR
{FIXED [Enrollee ID]:SUM([Calculation2])}]=2) THEN "Enrollee+Spouse"
Else "Enrollee"
end
Thanks
Deepak
If it Helps, Pl Mark it Helpful and CORRECT to close Thread

2. Re: Help with a Fixed LOD Calculation
Allan Merrell Jan 14, 2020 12:41 PM (in response to Deepak Rai)2 of 2 people found this helpfulThis got me where I needed to be. I thought I would share some slight modifications made to adjust for large families.
I also made a modification for 6 tiers using this same logic. Thanks again for your wealth of assistance here. I really appreciate it.