I'm trying to use a table which has the z values and it's matching percentile based on the z values I've generated. I was able to use the fieldindex value to create a column which each rows respective index but I just can't get how to reference the column next to the index's value to put in.
I'm currently trying to use the column() function to pass back where the index is equal so I can get its value but I keep getting - or error. Here is my function: ([-3.89] is the index row which goes from -.389, -3.88, -3.87... 3.97, 3.98, 3.99, [5.0122111001305e-05] is the column with the values i'm trying to get, and column(7) is the column containing the indexes of where the value I need to get is.
Only({<[-3.89]={"=column(7)"}>} [5.0122111001305e-05])
If this doesn't work, how can I easily return an element from a loaded data table using its index? I've already tried fieldvalue as well which didn't work.
