Alteryx Designer Desktop Discussions

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

Changing figures format

SH_94
11 - Bolide

Hi community,

 

Would like to ask if there is any that can result the issue below:

V_string format

SH_94_0-1634306520376.png

 

 

 

Use select tool to change to double

SH_94_1-1634306622543.png

 

May i know if there is anyway to maintain the original amount without reducing the number of decimal place after changin

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @SH_94 

 

I tried it lot of different ways since the latter value is very less its rounded instead of 0 if it was 1 it would still be there.

 

atcodedog05_0-1634307981328.png

 

Hope this helps : )

 

drew9
9 - Comet

Hi @SH_94 ,

 

Not a perfect solution, but you can convert it to a Fixed Decimal instead with a size of 19.15 to get more decimal places than a double will allow.

drew9_0-1634309892109.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @SH_94 

 

As @drew9 mentioned 🙂 you can use fixed decimal max precision is 16 decimal points (19.16).

 

Hope this helps : )

Labels