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
Solved! Go to 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.
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
User | Count |
---|---|
37 | |
26 | |
23 | |
17 | |
14 |