10 Replies Latest reply: Feb 13, 2017 10:03 AM by Srawan Srimant RSS

    Fetch the First Not NULL Value

    Srawan Srimant

      Hi All,

       

      Hope everybody is good.

       

      Can somebody please help me for the below scenario?

       

       

      YEARSALE
      2000
      2001
      2002
      2003678
      2004243
      2005800
      2006

      456

      I want an expression to fetch the first Year value having NOT NULL value of SALE.


      In this case I want 2003.


      Your Help is appreciated.


      Regards

      Srawan