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