Change data to Number with Decimals

[TNShan]

May I inquire about possible errors preventing the transformation of the data into the expected output?

Input	Output
4	4.0000
3.907	3.9070
3.9302	3.9302

[Qiu]

@TNShan 
We can change the Data to Fixed Decimal type.

[gawa]

hi @TNShan 

You should write expression like this, to have 4 digit decimal.

ToString([Level GPA],4)

Pls refer to online manual for detail.

https://help.alteryx.com/current/en/designer/functions/conversion-functions.html#idm45934712663104

[flying008]

Hi, @TNShan 

If you want to get string, use the formula:

ToString([Level GPA], 4)

[TNShan]

Hello, if the 'Scale' cannot be edited, could you kindly provide your advice on this matter?

[TNShan]

Hi, I'm uncertain whether the issue lies with my data, but the error persists.

[flying008]

Hi, @TNShan 

You must change your [Level GPA] type to string or New Field or use Multi-Filed Formula tool to change output type to your need.