9 Replies Latest reply: Oct 4, 2017 4:19 PM by Matthew McIlvride RSS

    Variables producing same result

    Matthew McIlvride

      I have a data set that looks something like this:

       

      EmployeeEarliest Event TimeLatest Event TimeTime Diff
      Adam08:0116:0007:59
      Beatrice08:0416:07
      Caroline07:5816:02

       

      Where Time Diff is a function that looks like this:

       

      =Interval( Max( EventTime ) - Min( EventTime ), 'hh:mm' )

       

      I tried to put this formula into a variable, but it fails to compute. Similarly, if I put Max( EventTime) or Min( EventTime ) into a variable, it computes, but all values are the same. I expect that this is due to it calculating max and min for the entire data set rather than for each employee. Is there a way to create a variable that computes for each employee?