Forum Discussion
cuohanele
Helper I
Helper ICONVERT TEXT TO NUMBER
Is there a way to change a text datatype to a number? Having issues with that. Maybe a way to bypass the error message that a text can't be converted to a number. I've tried advanced editor. Please h...
This method worked for me:
in the Transform data view, i Duplicated the original column, (under Add Column Menu, select the column, Duplicate Column menu item) , then Transform menu item the new column, make Data Type numeric. Numbers stayed behind as numeric and text items became blanks, which can be filtered out in the report.