Suppress if Percentage is Null 1

[gbobbie]

I currently have a report that is grouped by OFFICE. Individual PROVIDER fields are in the Detail section for each office. A provider number is being populated in our database for each provider and I only want to see those offices with 50% or more of providers without the number. Such as:

Office I wouldn't want to see:
DR. SMITH'S OFFICE
Dr. Smith 2242
Dr. John 8765
Dr. Lee ----

Office I would want to see:
DR. GRAY'S OFFICE
Dr. Gray ----
Dr. Doe ----
Dr. Davis 8865

How could I create a formula for suppressing only those with less than 50% null?

Any help is greatly appreciated!!

 

[lbass]

Try using group selection instead of suppression. Go to report->selection formula->GROUP and enter:

distinctcount({table.provID},{table.office})/distinctcount({table.drname},{table.office}) > .5

This assumes that the provID field is null and not just empty/blank.

-LB

 

[gbobbie]

Incredible, as always. Worked great, just had to turn the > to <. Thank you!