Use group by with If condition

[markgraham123]

Hi All,

I'm trying to create a flag by comparing Req vs actuals:

If Actual is less than Req for atleast 1 SubID - grouped by ID, then 'Check' else 'Good'

Please see attachment.

Any help is highly appreciated.

ID	SubID	Req	Actual
1	a	1	0
1	b	2	2
2	c	3	3
2	d	4	4
3	e	5	5

Req: O/P;

ID	SubID	Req	Actual	Flag
1	a	1	0	Check
1	b	2	2
2	c	3	3	Good
2	d	4	4	Good
3	e	5	5

[antoniotiman]

Hi Mark,

why ID 3 isn't  'GOOD' ?