Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate the difference between km for th same car

Hi everyone,

I would like to find an issue to look for the last "km d'arrivée" for the same car.

 

Here are my datas ("immatricultion" is the car plate reference, "kmde départ" and "kmdarrivée" are the km from the start and the end of the route, "datederetour" is the date when the user came back with the car) :

 

I would find out the difference between 132000 and 131487...one value per row to highlights the row which are wrong (difference not null).

Do you know what I mean? 😉 

I tried with summarize, with max, dateadd, earlier, filter...

 

Thank you for all your support,

Baptiste

3 Replies