-
1. Re: Absolute Enrollment vs. Discharged
Deepak RaiOct 16, 2018 3:38 PM (in response to Josh Ciszek)
-
Enrolled.twbx 5.7 KB
-
-
2. Re: Absolute Enrollment vs. Discharged
Josh Ciszek Oct 16, 2018 3:44 PM (in response to Deepak Rai)Deepak...this almost works. What I should have shown in my example is that the client could have anywhere from 1 to N enrollments. Thoughts?
I should have made client 456 have 3 different enrollments to make the point.
Let me know if you have ideas. Thanks.
-
3. Re: Absolute Enrollment vs. Discharged
Deepak RaiOct 16, 2018 3:46 PM (in response to Josh Ciszek)
Yes we can do..just paste some more data what is needed, let me know.
-
4. Re: Absolute Enrollment vs. Discharged
Josh Ciszek Oct 16, 2018 3:51 PM (in response to Deepak Rai)I can't seem to repost the table, but if you simply add the following record to the example table above...that would do it:
ClientID = 456
ProgramID = 6
EnrollDate = 7/1/2016
DisenrollDate = 12/31/2016
-
5. Re: Absolute Enrollment vs. Discharged
Josh Ciszek Oct 16, 2018 3:56 PM (in response to Deepak Rai)Maybe, instead of the static "2" you used...that can be replaced by a function that counts the number or rows for each fixed ClientID???
Would that work? What would that look like in your solution?
-
6. Re: Absolute Enrollment vs. Discharged
Deepak RaiOct 16, 2018 3:59 PM (in response to Josh Ciszek)
-
Enrolled.twbx 10.0 KB
-
-
7. Re: Absolute Enrollment vs. Discharged
Josh Ciszek Oct 16, 2018 4:14 PM (in response to Deepak Rai) -
8. Re: Absolute Enrollment vs. Discharged
Deepak RaiOct 16, 2018 4:16 PM (in response to Josh Ciszek)
Your Picture is too small
-
9. Re: Absolute Enrollment vs. Discharged
Josh Ciszek Oct 16, 2018 4:19 PM (in response to Deepak Rai) -
10. Re: Absolute Enrollment vs. Discharged
Deepak RaiOct 16, 2018 4:28 PM (in response to Josh Ciszek)
-
Enrolled.twbx 10.0 KB
-
-
11. Re: Absolute Enrollment vs. Discharged
Josh Ciszek Oct 16, 2018 4:36 PM (in response to Deepak Rai)Deepak...it seems to work. I am staring at this and have no idea why it works though.
-
12. Re: Absolute Enrollment vs. Discharged
Deepak RaiOct 16, 2018 4:37 PM (in response to Josh Ciszek)
-
13. Re: Absolute Enrollment vs. Discharged
Josh Ciszek Oct 16, 2018 4:38 PM (in response to Deepak Rai)Thank you so much! But why does that work?
-
14. Re: Absolute Enrollment vs. Discharged
Josh Ciszek Oct 16, 2018 4:40 PM (in response to Deepak Rai)I just realized why! It's based on the alphabet of the first letter of the words Enrolled or Discharged.
That is Brilliant! Thank you