Virtual formula not working

Hi

I have the following expression in a virtual column:

INDEX([OrderBy Random][Starting Position],[Starting Position])

It automatically adds a random position to a car in the # column, it works for all rows besides the last one I don’t know why. Here’s the screenshot:

Any ideas why the formula doesn’t work?

Please provide more info about the columns and tables in question.

What is [OrderBy Random]?
What is [Starting Position], and why are there no values displayed for that column in your screenshot?
Is there a [Starting Position] in 2 different table, or what?

1 Like