2 Replies Latest reply on Jan 14, 2020 12:41 PM by Allan Merrell Branched from an earlier discussion.

# Re: Help with a Fixed LOD Calculation

Now I am getting another request for an additional tier for when an enrollee has multiple kids. This will give us 5 total tiers being Enrollee, Enrollee+Spouse, Enrollee+Dependent, Enrollee+Dependents and Family.

Do you have another magic trick in that wand?

 Enrollee ID Member First Name Member Last Name Relationship Unique Member ID Relationship Group 1 Bname First Enrollee Abcd1 Enrollee + Dependent 1 Lname First Daughter Abcd2 Enrollee + Dependent 2 Kname Two Enrollee Abcd3 Enrollee + Dependent 2 Gname Two Daughter Abcd4 Enrollee + Dependent 3 Sname Third Enrollee Abcd5 Enrollee + Spouse 3 Dname Third Husband Abcd6 Enrollee + Spouse 4 Cname Happy Enrollee Abcd7 Enrollee + Dependent 4 Aname Happy Daughter Abcd8 Enrollee + Dependent 5 Cname Person Enrollee Abcd9 Enrollee + Dependent 5 Nname Person Son Abcd10 Enrollee + Dependent 6 Pname Apple Enrollee Abcd11 Enrollee + Spouse 6 Bname Apple Wife Abcd12 Enrollee + Spouse 7 Wname Solo Enrollee Abcd13 Enrollee 8 Aname Cosby Enrollee Abcd14 Family 8 Bname Cosby Wife Abcd15 Family 8 Cname Cosby Son Abcd16 Family 8 Dname Cosby Daughter Abcd17 Family 9 Ename Gold Enrollee Abcd18 Family 9 Fname Gold Wife Abcd19 Family 9 Gname Gold Son Abcd20 Family 10 Aname Silver Enrollee Abcd21 Enrollee+Dependents 10 Bname Silver Son Abcd22 Enrollee+Dependents 10 Cname Silver Daughter Abcd23 Enrollee+Dependents
• ###### 1. Re: Help with a Fixed LOD Calculation

Yes, 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

1 of 1 people found this helpful
• ###### 2. Re: Help with a Fixed LOD Calculation

This 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.

2 of 2 people found this helpful