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

    Allan Merrell

      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 IDMember First NameMember Last NameRelationshipUnique Member IDRelationship Group
      1BnameFirstEnrolleeAbcd1Enrollee + Dependent
      1LnameFirstDaughterAbcd2Enrollee + Dependent
      2KnameTwoEnrolleeAbcd3Enrollee + Dependent
      2GnameTwoDaughterAbcd4Enrollee + Dependent
      3SnameThirdEnrolleeAbcd5Enrollee + Spouse
      3DnameThirdHusbandAbcd6Enrollee + Spouse
      4CnameHappyEnrolleeAbcd7Enrollee + Dependent
      4AnameHappyDaughterAbcd8Enrollee + Dependent
      5CnamePersonEnrolleeAbcd9Enrollee + Dependent
      5NnamePersonSonAbcd10Enrollee + Dependent
      6PnameAppleEnrolleeAbcd11Enrollee + Spouse
      6BnameAppleWifeAbcd12Enrollee + Spouse
      7WnameSoloEnrolleeAbcd13Enrollee
      8AnameCosbyEnrolleeAbcd14Family
      8BnameCosbyWifeAbcd15Family
      8CnameCosbySonAbcd16Family
      8DnameCosbyDaughterAbcd17Family
      9EnameGoldEnrolleeAbcd18Family
      9FnameGoldWifeAbcd19Family
      9GnameGoldSonAbcd20Family
      10AnameSilverEnrolleeAbcd21Enrollee+Dependents
      10BnameSilverSonAbcd22Enrollee+Dependents
      10CnameSilverDaughterAbcd23Enrollee+Dependents
        • 1. Re: Help with a Fixed LOD Calculation
          Deepak Rai

          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
            Allan Merrell

            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