Forum Discussion
Error based on a column
smokeyjoe03 , but i need to keep that "Less than year" value in my column along with the numerical values . How can I go about it?
The column will have to remain as a string in that case, the "Change Type" operation operates on every value in the column so even just 1 value that isn't a number or NULL will cause the error.
As a workaround I suggest making two columns:- A Number column but replace your "Less than a Year" with a 0. This will allow you to use this column to do mathematical operations still.
- A String column that keeps the numbers as strings and allows the value "Less than a Year". This can be used for display purposes.
It would look something like this:
YearsColumn (Number) DisplayColumn (Text) 0 Less than a year 1 1 5 5 Thanks for the solution smokeyjoe03
smokeyjoe03 , but i need to keep that "Less than year" value in my column along with the numerical values . How can I go about it?
The column will have to remain as a string in that case, the "Change Type" operation operates on every value in the column so even just 1 value that isn't a number or NULL will cause the error.
As a workaround I suggest making two columns:
- A Number column but replace your "Less than a Year" with a 0. This will allow you to use this column to do mathematical operations still.
- A String column that keeps the numbers as strings and allows the value "Less than a Year". This can be used for display purposes.
It would look something like this:
| YearsColumn (Number) | DisplayColumn (Text) |
| 0 | Less than a year |
| 1 | 1 |
| 5 | 5 |
Thanks for the solution smokeyjoe03