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 need the number value in "UNIT PER ASSY"
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
6 Replies
KGriceMemorable Member
I tried to recreate and don't get the error. Can you click in the white space of the one the cells, next to the word Error? That should give an idea of what's going on in a message at the bottom.
- Vvelarde
Community Champion
Anonymous
Your decimal is with . or with ,
Maybe change this in Conditional colum 0,0 instead 0.0
- KGrice
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
