I have a report where i am trying to display the client if the client does not have an admission type diagnosis.

 

The client may have the following types of diagnosis admission, update, onset, or discharge. However all clients must have an admission diagnosis and i am trying to create this report where i can pull those clients whom do not have an admission type diagnosis.

 

here is what i tried. In the select expert i selected admission_type_dx_value and said is not one of "admission" however this is not working because it just excludes all the admission diagnosis for all clients and if they have another type of diagnosis they are displayed in my report which is incorrect

 

Im guessing i need some type of formula to evaluate if any of the rows of diagnosis entered have the field admission_type_dx selected as "admission"

 

am i being cofussing? 

 

this worked

 

The only difference was that i selected the sum in the select expert and said is less than or equal to 0

 

Again I am greatful for your response