2 Replies Latest reply: Jan 16, 2013 3:24 PM by Daniel Rozental RSS

    Max and Lookup in Straight Table

      Can someone help me return the correct SG_Status based on the max(SG_ID)?  The answer in the form of a straight table would be as follows, but I don't know how to solve for it. As you can from my file see I only return nulls with the exception of the first row

       

      Report_ID
      max(SG_ID)SG_Status
      100011
      100122
      100233
      10044

      2

       

      Thanks