1 Reply Latest reply: Sep 8, 2012 8:20 AM by whiteline _ RSS

    Help with Expressions please

      If I have a table containing data like this:

      pic3.png

      Please could someone tell me how to write expressions to show:

       

      • The fewest number of minutes spent by anyone on a Problem Code (please note that every time someone spends time on a call it creates a seperate entry, so I would need to sum the time spent for each call linked to the problem code and show the lowest sum) - looking for a team record.
      • The fewest number of minutes spent by the individual I am looking at on a Problem Code - looking for a personal best.

       

      Thanks.