Conversion Error for number

[SH_94]

Hi community,

I would like to ask how do we solve the conversion error issue for the following number :

Original input ( Datatype format - Vstring)

After converting ( Datatype format - double)

i use the select tool to change the datatype from Vstring to double.Would like to ask how do we normally convert data if there is long decimal number and avoid the conversion error issue.

THank you.

[Qiu]

@SH_94 
Maybe we can try the Fixed Decimal?

---

Alteryx defaults a Fixed Decimal to 19.6. The maximum precision is 50, inclusive of the decimal point and negative sign (if applicable).

A standard double-precision floating-point value. It uses 8 bytes and can represent values from +/- 1.7 x 10-308 to 1.7 x 10308 with 15 digits precision

---

[SH_94]

Hi @Qiu ,

May i know how to change to fixed decimal in this case?

Thank you.

[ShankerV]

Hi @SH_94 

There are two ways to change the datatype to fixed decimal.

1. Via Select tool

2. Multi Field Formula tool

Many thanks

Shanker V

[ShankerV]

Hi @SH_94  

To explain you why I have used the FixedDecimal as 18.14 is

I see the data's in your screenshot. Its all 18 characters long including the .(full stop)

380.26637996835586

Hence I have used the full length as 18 and the precision as 14

Hope it helps!!!!

Many thanks

Shanker V

[binuacs]

@SH_94 This is not a conversion error, it is the information, when you convert a large number into double data type alteryx round the number to the nearest 6 decimal places.