1 Reply Latest reply: May 12, 2017 3:07 AM by Antonio Mancini RSS

    Use group by with If condition

    Mark Graham

      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.

       

       

      IDSubIDReqActual
      1a10
      1b22
      2c33
      2d44
      3e55

       

       

      Req: O/P;

       

      IDSubIDReqActualFlag
      1a10Check
      1b22
      2c33Good
      2d44Good
      3e55