Create Formula to Tally Cases 1

[CJP12711]

Hello, I'm using CR10. I have a data set like the one below:

case 1
type Diagnostic

Case 2
type Diagnostic
type Interventional

Case 3
type Interventional

I want to ignore all cases that have a type of Diagnostic only, or cases that have a type of Interventional only. I want to count the cases that have both Diagnostic and Interventional as the type. Can anyone help me with this?

Thanks,
CJ

 

[lbass]

Insert a group on case ID and then insert running total that does a distinctcount of caseID, evaluate using a formula:

distinctcount({table.type},{table.caseID}) > 1

Reset never.

Place the running total in the report footer.

-LB

 

[CJP12711]

Thanks lbass - that worked perfectly!!!!!