I have used a population effective date and end date to come up with a (Pop Code Eligibility months) variable over one year. example: If [Effective date] <= '01/31/2016' and [End date] >= '01/01/2016' Then "January" ElseIf [Effective date] <= '02/29/2016' and [End date] >= '02/01/2016' Then "February" .........
The result of my formula is only giving me only one month that the Bene ID exists instead of all the months the Bene ID exists, I have run out of options and I need help if anyone can give me some directions.
I broke down my formula to create single months and I can see they all bring back each of the months but when I am having a hard time coming up with a formula to count all the months that the Bene ID exists in.
The alternative is to calculate the Bene ID for each of the months it exists in for given pop codes, I need help with this count too. My Summary table is giving me a very low count.
If I can get my formula to display the Bene ID with the two months I think this will set me on the right path.
See attached sample datasample-data.jpg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.