TONUMBER Lost information in conversion

[jmedidi]

I am trying to convert string to Float and getting the below conversion error. is this something that can be fixed ?

ConvError: Formula (109): TONUMBER: TBD lost information in conversion

[BrandonB]

You most likely have a non number character within the text. This could be commas or letters. Maybe do a quick check through your data looking for these characters, and do some data cleansing prior to your formula? This is specific to your TBD column. 

[atcodedog05 · Accepted solution]

Hi @jmedidi 

It's because TBD is not a number and might be converted to 0 which might be a misrepresentation. You would need to handle this before converting.

Hope this helps : )

[jmedidi]

Gotcha. It was oversight from my side. Will do the conversion in the fields with TBD values to Null before Float conversion. Thanks.

[atcodedog05]

Yup thats right @jmedidi 🙂