Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Float conversion Issue

sumeet_rk
7 - Meteor

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

4 REPLIES 4
aatalai
15 - Aurora

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

sumeet_rk
7 - Meteor

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
15 - Aurora

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
9 - Comet

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

 

 Float conversion.png

Labels
Top Solution Authors