4 Replies Latest reply on Jun 4, 2013 10:26 AM by Stanley McLenna

    Comparing Value in Row to the Next Row - LOOKUP()?

    Stanley McLenna

      I need to compare the value in Row A to the value in the next row and then return a value either TRUE or FALSE. I considered using a LOOKUP function to reference the next value in the data set, but it doesn't return the expected results:

       

      LOOKUP(ATTR([Timestamp Date]),1)

       

      I expected the function above to return the Timestamp Date value in the next row, but it returns NULL. Any ideas?