Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jvander2
Contributor

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])))

Labels (4)
1 Solution

Accepted Solutions
Lisa_P
Employee

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])))

View solution in original post

2 Replies
Lisa_P
Employee

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
Contributor
Author

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