elimeting duplicate jobs

[tkaplanusmc]

my report is showing duplicate jobs due to the fact that some of the promised dates are different. All I want is the earliest date for a current job not the extras. I've tried to supress duplication but the feilds are still showing up. any suggestions on a select expert formula that may help me accomplish my goal?

below is the output im getting.

PLANNING 24 0.00
Job Promised date @late
15120 8/2/2010 0.00


15758 6/25/2010 0.00


7/23/2010 0.00


15759 7/23/2010 0.00


8/27/2010 0.00


15761 8/2/2010 0.00


8/9/2010 0.00


8/23/2010 0.00

 

[tkaplanusmc]

Disregard my last I found a solution in the forums after a bit of digging. Thanks again lbass you helped me once again indirectly.

 

[lbass]

I'm guessing you used group selection:

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

(Just so this helpful to other readers.)

-LB