Query #1121 vs #1097

[Erik@AD]

I am trying to get some demographics by zip code and these queries return quite some different values.
1249 vs 1337 for a certain zip code for example.

My questions are:
Which query is most accurate?
What is causing these significant differences?

Thanks,

-Erik

[cmcgehee]

Both queries are equally accurate; they are just measuring different things. #1121 will count a patient only if they had a completed procedure in the date range. #1097 will display a patient if their zip code is in the list supplied regardless of if they have any completed procedures.

[Erik@AD]

I forgot to add that I (Excel) counted the zip codes where "production>0" in #1097, which reduced it from 5191 to 1249.

[cmcgehee]

That sounds like your numbers match. Technically it is still possible for them not to match after you remove patients with $0 production. If a patient's only completed procedures have procedure fees of $0, they would appear on #1121 but then get filtered out of #1097.

[Erik@AD]

Ok thanks.

-Erik