Use group by with If condition

markgraham123 — Thu, 11 May 2017 16:33:11 GMT

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.

Req: O/P;

Re: Use group by with If condition

antoniotiman — Fri, 12 May 2017 07:07:14 GMT

Hi Mark,

why ID 3 isn't 'GOOD' ?