Minimum and Maximum Values within a Group, then Calculate Time DIffer

[eric333]

Hello,

I have a series of transactions in a table. Each transaction is associated with a tracking number and has a date/time. There are multiple transactions for each tracking number. I have grouped the transactions by tracking number.

I want to identify the first (minimum) transaction within the tracking number group, then last (maximum) transaction within the tracking number group, then calculate the difference between the two. Ultimately, I will want to total the calculation of all of the time for each tracking number.

I can handle the time calculations using DateDiff and the overall total using just a simple summary. But, how do I identify the minimum and maximum transaction within each group?

Thanks!!!!

 

[IdoMillet]

Simply use minimum or maximum({transaction_date}, {tracking_number})

The second argument controls the grouping level of the summary.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[eric333]

Thank you VERY much.

BTW - HUGE fan of your software.