9 Replies Latest reply: Sep 17, 2014 9:37 AM by Carmalita Griffin RSS

    How to create expression to do a calculation using previous record value

          I need to create an expression for a straight table for a column to subtract previous surgery stop time from the next surgery start time, if on same day.   I've tried using variables but discovered you can't set those values in an expression.  I don't know how to check if 1) the same date and 2) use previous records' stop time.   Is that possible in an expression?