No worries, looks like you're doing OK.
I would like to know the bottom scores of the top 20.
I'm confused by this. You want to know the
bottom scores of the
top 20? Just want to make sure I'm reading that correctly.
You didn't specify how many of the bottom scores, or what to do with them.
So, for example, do you want to know the lowest score of the top 20 scores? You could do that like this:
bottom(1, top(20, scores))That would show the lowest score of those top 20 scores. But you have to do
something with it if you want more than 1 score, since the entire formula must return only a single value. For example:
bottom(3, top(20, scores))This would error, because it returns 3 values and the Overall Score must be a single value. But this would work:
sum(bottom(3, top(20, scores)))So, what are you looking for?