Float conversion Issue

[sumeet_rk]

I am trying to convert a string into float , But its rounding to nearby number.

Can someone please try to explain

(6789989.98)  - > (6789990) -> This is incorrect , I need the value exactly

[aatalai]

@sumeet_rk try using fixed decimal that goes up to 50 dp

[sumeet_rk]

Thanks for the response , I have tried using fixed Decimal , but it still convert the above number to (6789990) instead of (6789989.98)

 (6789989.98)  - > (6789990)

[aatalai]

are you using the select tool or the formula tool (create a new field and say tonumber([field])) to convert it? Also stick a browse after it as the results pain might only be showing partial results

[kamal03 · Accepted solution]

Try using below method , Let me know if it works for you or not ,thanks