I'm having to calculate the initial and end coordinates to draw a trend line (linear regression line).
To do so, I put the values of my points in a graph in a datastore and one of the computed columns is X2.
The only problem I'm having, is that my X column is a long value. X2 would be X * X and I'm getting an overflow.
Does anyone know what the maximum numeric datatype is for a computed column?
regards
I've changed the value to decimal(0) and now it works ok.
I was having a long value before and I was getting -241......
It seems that the computed column bases it's datatype on the values you use within its expression, which seems logical in a way.
Thanks!