Comments
-
Thanks guys for your replies I appreciate the help. @Grant this would work, but it greatly increases my row total which I don't want to do in this particular case. @ST_Superman I am implementing this now and it appears to be working.
-
No, I found the problem. I need to have multiple filters as I was also filtering by dates. Thanks for the suggestion though, I appreciate you responding.
-
So I can filter out those specific Procedures, but that Patient and their aptnum will still show up in the drill path, because those procedures only take up one row of what is normally 4-5 rows associated with that appointment if that makes sense.
-
Thanks Mark, that is currently what I'm doing, but I was holding out on the hope that somebody had come up with a different solution.
-
Braxton, Yea, that makes sense. I wondered if that might be the problem. Thanks for your help in resolving this.
-
Hey Braxton, Thanks for your help. I'm still having the same issue with that update. So for example, in the month of September the goal is 2.82 M and the production we have already schedules is 1.65 M, thus, we are short 1.17 M of the goal. So I want to divide that by 30 and get the end result of needing 55K a day…