Hi everyone. I've been using CR for about 2 weeks now and loving it, but I've run into a problem.

I'm creating a report from an SQL database to track warehouse picking productivity. There are two fields in question, we'll call them Time and User. I've figured out the formula to calculate the gap time between picks, that is the gap between lines in the Time field. See this example:

Time   User   Gap
1:15   1      
1:20   1      :05
1:25   1      :05
3:00   2      1:35
3:05   2      :05

As you can see, when changing from user 1 to 2, the formula still finds the difference between their pick times. How can I stop this?

Thanks in advance for any help given!

Incredibly simple - I can't believe I didn't figure it out!

Thanks a ton!