Trying to display tkt # of number is matched

[dacards]

Here is what I have:

Create Date Value 2 Tkt # Elapsed Time
5/30/06 8:00 AM 5/30/06 9:30 AM 123 1.5
5/29/06 1:00 PM 5/29/06 5:00 PM 214 4
5/29/06 2:00 AM 5/29/06 3:00 AM 215 1

The formula for the column on the right(Elasped Time) is @value2 minus create date):
({MOD_TRB_Value 2 Timestamp}-{MOD_TRB_Create Date})*24


I have a 2nd formula (@Oldest Tkt In Queue) to show the longest elapsed time:
maximum({@value 2 minus create date})


I'd like to set up a formula to display the ticket # that is associated with the maximum elasped time(for this example its 214). I attempted the following which was no help:

if {@value 2 minus create date}={@Oldest Tkt In Queue} then {MOD_TRB_TT Request ID}


Any and all help is appreciated.

 

[synapsevampire]

Create a formula of:

whileprintingrecords;
numbervar tkt;
if ({MOD_TRB_Value 2 Timestamp}-{MOD_TRB_Create Date})*24
= maximum({@value 2 minus create date}) then
tkt:= {table.ticket};
tkt

The you can display in the report footer using:

whileprintingrecords;
numbervar tkt

-k