Hello,

I have date like this

Patient Code
x1        150.1
x1        170.5
x1        ABC
x1        230.00
x1        001.5

I need data specific to patients who has both 150.1,ABC codes. If I filter "code" I am not getting data.

When I use group by and create formulas
@code1: if code1 = '150.1' then 1 else 0
@code1: if code2 = 'ABC' then 1 else 0

In group selection I use sum(code1) = 0 and sum(code2)= 0 I am getting data I am looking for. However when I ran the report for huge amount of data report is running relatively.

Can you show me another way to solve this besides Aliasing or group by ?

yes I can write command.