aggr function problem

[GraceGao]

Hi Experts,

I have below fields.  could any one help? 

employee, address, case no. distance. distance is the nearest distance by employee.

employee	address	case no.	distance
1	a1	566	0.4
1	a2	454	3

i used aggr(distance, employee) and result is as below.

employee	address	case no.	distance
1	a2	454	0.4

 my expected result as below in table chart.

employee	address	case no.	distance
1	a1	566	0.4

[lironbaram]

hi

this expression should work for you 

if(distance=min(total<employee> distance),distance)

[GraceGao]

Thanks but i have one problem, i found No.2 employees distance is zero, then 

how can i get the second nearest distance record when nearest distance is zero?