Help need a refresher - Count if?

[Former Member]

Please forgive me for what I'm sure is a basic function - I took a 3 day Webi course last year and had no need to use the application until now. (I've forgotten everything)

I've created a query with Patient ID, Entity, Discharge month

I want to create a report that shows for each Entity by month

Total patient count & total patient count that have a set of specific codes

I've created the total patients variable but I can't remember how to show a measure that counts the patients that have the codes I'm looking for out of the patients group

Please Help

Steve

[Former Member]

Steve,

The following should do the trick for you:

=[Total Patients Variable] Where ([Codes] InList ("x";"y"))

[former_member817653]

Hi Steve,

You should try something like

=count(Patient ID where <conditon for specific codes>)

Hope this helps.

Regards,

Mathangi

[Former Member]

THANKS!