8 Replies Latest reply: Oct 6, 2014 9:45 AM by ilgmars dakulis RSS

    Return first data for last negative value period

      Hello,

       

      I need return first Date for last negative Value period.

       

      Table:

      INLINE [ID, Date, Value

      1, 1/1/2014, -3

      1, 1/2/2014, -4

      1, 1/3/2014, -9

      1, 1/4/2014, -7

      1, 1/5/2014, 6

      1, 1/6/2014, 4

      1, 1/7/2014, -5

      1, 1/8/2014, -3

      1, 1/9/2014, -7

      ];

       

      Need add field with marked 1/7/2014 for ID=1

       

      Thanks for advice!

       

      BR

      Ilgmar