Hi everyone.
I have a data set with the following column. The column is currently STRING and I need it to be numerical. I think the TBD is preventing me from doing so using the Select tool, so I want to change the TBD to 0, then use Select to change the column to NUMERICAL.
Or is there a better way of doing this?
Value |
100000 |
150000 |
375000 |
TBD |
50000 |
TBD |
Thanks,
KA
Solved! Go to Solution.
Try one Formula tool.
IF [Value] = "TBD" THEN 0
ELSE ToNumber([Value])
ENDIF
Chris
Thank you, Chris!