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

    Calculate date difference between consecutive rows


      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.



      - One LOG ID = 0 days diff

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


      Thanks in advance.