Participation Rate Calculation

[jvander2]

I am trying to figure out the participation rate for our company's medical benefits (Enrolled vs Eligible). I need to look at just the current report effective date data and I need to just to include those that are enrolled in each plan divided by those that are a part of a benefit group that is eligible for medical benefits. This is what I have and just need some guidance to make it work.

(Count(distinct {<
[ReportEffDate]={$(=Max([ReportEffDate]))},
[MedicalPlan]={'Medical-Anthem Choice PPO', OR 'Medical-Anthem HDHP-Core', OR 'Medical-Anthem HDHP-Value'}
>} [ID])

/

(Count(distinct {<
[ReportEffDate]={$(=Max([ReportEffDate]))},
[BenefitGroup]={'ACA Regular Part Time', OR 'ACA Only Benefit Group', OR 'Hourly', OR 'Salaried'}
>} [ID])))

[Lisa_P · Accepted solution]

Try removing the ORs as this is not correct syntax in Set analysis. Using commas will do this automatically....

(Count(distinct {<
[ReportEffDate]={$(=Max([ReportEffDate]))},
[MedicalPlan]={'Medical-Anthem Choice PPO',  'Medical-Anthem HDHP-Core',  'Medical-Anthem HDHP-Value'}
>} [ID])

/

(Count(distinct {<
[ReportEffDate]={$(=Max([ReportEffDate]))},
[BenefitGroup]={'ACA Regular Part Time',  'ACA Only Benefit Group',  'Hourly',  'Salaried'}
>} [ID])))

[jvander2]

Thank you so much Lisa_P! That was the issue. Thank you!