Forum Discussion
if statement with text and number error
Trying to convert a mixed column of letters and numbers to all numbers. It is giving me an error when it actually is a number in the column. Where you see "Error" in the "Unit Per ASSY Fix", I...
That error still seems odd and I'd like to figure it out just to learn, but if all you want to do is grab the number and otherwise count it as 0, you could bypass the whole conditional column and try Add Custom Column instead. Use the formula below:
=try Number.From([UNIT PER ASSY]) otherwise 0
I started by just putting in 0 but I changed it to 0.0 to see if that would fix the problem.
So in short, I would like it to be 0 if the column is non-numeric and the number if a number.
KGrice
Memorable Member
Memorable MemberThat error still seems odd and I'd like to figure it out just to learn, but if all you want to do is grab the number and otherwise count it as 0, you could bypass the whole conditional column and try Add Custom Column instead. Use the formula below:
=try Number.From([UNIT PER ASSY]) otherwise 0
That worked perfectly! Thank you