
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Participation Rate Calculation
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])))
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much Lisa_P! That was the issue. Thank you!
