3 Replies Latest reply: May 30, 2016 10:59 AM by beng chai chew RSS

    Straight table calculation of elapsed day between two dates in two adjacent row

    beng chai chew

      I have extensive straight table with lot of calculated field. I had problem computing "Batch Cycle Length" which takes date from two adjacent row.

       

      See attached sample illustration for below issue:

       

      Batch Cycle Length (days) = Batch Start Date (first row) - Batch Start Date (adjacent row)

       

      I am thinking to use array for the expression but don't know how.

       

      Thank you.