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
8 - Asteroid

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

 

 

 

2 REPLIES 2
binuacs
20 - Arcturus

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

CSmith16
8 - Asteroid

@binuacs 

 

Awesome, thank you man!

Labels