Racing position

[sherazade]

I'm stuck, cannot understand how to solve this problem:

I need to show the results of a race where

No= pilot numer

Name= pilot name

Time= timing

Penalty= a time that is added to Time

Time+Pen=  is the time that has to be used to compute the final result, shown in Pos

No	NAME	Time	Penalty	Time+Pen		Pos
4	A	00:00:30	00:00:00	00:00:30		1
5	B	00:00:45	00:00:00	00:00:45		2
2	C	00:01:15	00:00:00	00:01:15		3
6	D	00:01:15	00:00:00	00:01:15		3
3	E	00:01:35	00:00:00	00:01:35		5
1	F	00:01:30	00:00:30	00:02:00		6

I have to show the result in Time+Pen ascending order, and this is ok.

I also need to show in Pos  where  value1 is first classified, 2 is second... etc  

in this case pilots (No 2 and 6)  have same Time+Pen value,  both have to be classified  in same ranking, and and next Pilot has to have a value +1

how can I compute this Pos field?

thanks a lot!!!!!!!!!!!!!

[Aurelien_Martinez · Accepted solution]

Hi,

In simple table, I'm using Rank(TOTAL -(Time + Penalty), 1)