Racing position

sherazade — Fri, 25 Nov 2022 10:10:42 GMT

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

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!!!!!!!!!!!!!

Re: Racing position

Aurelien_Martinez — Fri, 25 Nov 2022 11:03:12 GMT

Hi,

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