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

    Variables producing same result

    Matt McIlvride

      I have a data set that looks something like this:


      EmployeeEarliest Event TimeLatest Event TimeTime Diff


      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?