Forum Discussion
Search criteria in a field to evaluate if an event happened within 30 days pre and post
Thanks, Phillip! I appreciate your patience while I looked into this. I do believe this is working. I understand you used a table so the formula is a table reference, which is the only way I could get this to work. I also understand that the formula is looking for the CPT description to start with "Office" or "Administered Chemo."
Question: Since the example provided was a short sample size, I wanted to confirm whether the resulting value will be the number of qualified instances that meet the condition, correct? The resulting value can be something other than "0" or "1," right?
Also, much of what we do is based on values as opposed to descriptions. For future application of this formula, if CPTs 99201-99205 and 99211-99215 are office visits, and 96401-96549 are administered chemo, how would the formula have to be altered to incorporate the vlookup(s)?
Thanks so much for your help on this; I was wracking my brain on this one.
Best,
Chris
Hia,
I'm glad that we are making progress :)
Yes, the formula is counting the number of occurrences before and after that meet the criteria, so anything more than 0 is a match. The two columns that show the counting are only there so you can see more easily what is happening in larger the formula. You can delete them if you like, they aren't needed.
So Indicator and Indicator 2 are basically the same thing, they differ in that Indicator 2 doesn't care what sort of visit happened in the 30days, any entry in your table will do. Indicator makes a distinction between an office visit and an chemo session. In your example this was easy as it was just a case of looking for the words 'Administered Chemo'. If in the live version you use something else, then you can just substitute the words Administered Chemo for that something else. So it could be "=96401-96549".
It gets slightly harder if you have several criteria for what might be a chemo visit.