If() statement not working

[Sophtee]

Hey everyone, so I asked a similar question before I seem to have a problem with this IF() statement:

I am trying to let the IF() statement be: IF (the start mileage = to the end mileage), "Continue", "Error")

Datasheet, so I expect the next entry for the start mileage to be 2000 if anything else say "error"

But it's not changing

[shahappsheet · Accepted solution]

Hi @Sophtee .

Start mileage should be [Start Mileage]. 

Another thing is that it might be, [Vehicle Number]=[_THISROW].[Vehicle Number]. I dont know your design but it seems to me [_THISROW] might be necessary in this scenario.

[Sophtee]

I am feeling to cry "tears of joy".....Thank youuuuuu sooooooooo much .. 

I have been at this for two days... so thank you and to everyone who helped in the previous post