1 Reply Latest reply on Jul 25, 2016 10:28 AM by Luciano Vasconcelos

    Calculate date difference between consecutive rows

    paolo.raia

      Hi there,

       

      I've been trying to use LOOKUP with MINI/MAX, but I am not getting the required results.

       

      I simply want to calculate the day difference between each row (Days Diff column) and restart the calc at each LOG ID:-

       

      The table above is sorted by LOG ID then DATE.

       

      So.....

      - One LOG ID = 0 days diff

      - Multiple LOG ID's = calculate difference of days between rows

       

      Thanks in advance.