Hi everyone
i want to create a standard deviation or Min / max calculation from a single value column but i can’t. Can you tell me if there’s a trick to allow this ?
I used the miracle method of Robert Pettito to transpose row into column but i’m stuck at this point.
thanks for help
PS
It seems like the array is coming from a string, which makes all the array elements strings, not numbers
Exactly. There’s a trick you can do to convert a string value into a number value. Use a math column and enter 0+0+ variable with that variable is the value you want to convert.
Haven’t tried, but maybe variable*1 also works.
If 0+0+ variable doesn’t work, try -0+0+ variable.
