This content has been marked as final. Show 3 replies
I'm trying to create a worksheet that calculates benefits participation rates among people who are eligible for benefits and by specific benefit type. The problem I'm having is that my sheet keeps returning 100% participation, which is not true.
I'm using the following 3 data sources (tabs in the attached Excel file):
When I only inlcude the tblEligible and the tblParticipants data sets I get the correct calculation (75%). When I include Benefit I get 100%.
Any help would be appreciated.