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
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 : )
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.
Gotcha. It was oversight from my side. Will do the conversion in the fields with TBD values to Null before Float conversion. Thanks.
