minimum date 1

[newCrystalgirl]

Hello -

I have a table which includes the following fields:

ID Task Task Result Date
ABC Edit Pass 02/23/2006
ABC Edit Pass 02/25/2006
EFG Edit Pass 02/26/2006
HIJ Edit Pass 03/01/2006
XYZ Edit Pass 03/03/2006

I am trying to build a report based on only the records that have the earliest date tied to the ID. For example, I want to include the first record for ID ABC with the date of 02/23/2006, but don't need to pull in the other record for ID ABC.

I have a grouping based on ID and inserted a formula field using minimum{table.Date}. However, it displays just one date which is the minumum date for the entire table.

Any suggestions on how i can fix this?

Thanks

 

[Juice05]

Try changing your formula to look at the {Group.Date} rather than the {table.Date}

 

[lbass]

Go to report->selection formula->GROUP and enter:

{table.date} = minimum({table.date},{table.ID})

If you need to do calculations across IDs, you will need to use running totals, since non-group selected values would contribute to inserted summaries.

-LB

 

[newCrystalgirl]

Thanks LB! This worked perfectly.