In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

V_String to Double. Truncates data

CSmith16
9 - Comet
‎06-12-2023 09:10 AM

Hello,

 

I am trying to change a data type from V_String to Double and when doing so it completely changes the number. Any suggestions?

 

Original:

CSmith16_1-1686586076622.png

CSmith16_2-1686586084507.png

 

New:

CSmith16_3-1686586115216.png

CSmith16_4-1686586123770.png

 

 

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
binu_acs
21 - Polaris
‎06-12-2023 09:13 AM

@CSmith16 Use the function toNumber([Amount]) in the formula tool to convert it into double data type

Reply
CSmith16
9 - Comet
‎06-12-2023 09:14 AM

@binu_acs 

 

Awesome, thank you man!

Reply
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All