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

      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.