I have a column of values, let's say column A, that if I do =isnumber
on any of the column data it returns TRUE
.
Now after I =query
and select A
, the query gives me the right values, but the type has changed. Now if I do =isnumber
on the column it gives me FALSE
I even tried to * 1
to column A (i.e., select A * 1
) the error is the following:
Error: Unable to parse query string for Function QUERY parameter 2: Can't perform the function product on values that are not numbers
Well clearly 1
is a number and column A is a number; I just used =isnumber
on it, and the return is TRUE
.
My query is pretty big, but I don't think it should affect anything. I'm going out to column CZ
and there are about 1000 rows.