Start Free Trial

Alteryx Designer Desktop Discussions

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

Increase Precision of Decimal

BRRLL99
11 - Bolide

I have following data set in Fixed Decimal 19.2

I want to increase the precision of the decimal

 

input:

 

Amount
-53.61
57.29
-34.56
52.68
-46.9
-6.3

 

Expected output:

the end datatype should be in Numerical

 

-53.61
57.29
-34.56
52.68
-46.90
-6.30
4 REPLIES 4
Deano478
12 - Quasar

@BRRLL99 if you look at the below WF i just set the data type to Fixed decimal 19.2 and got the desired result.

 

 

BRRLL99
11 - Bolide

Im using 

Version: 2022.3.1.553 Patch: 6

if i convert to 19.2 fixed decimal

 

it is giving me 46.9

and 6.3 only

 

please share your screen shot

BRRLL99
11 - Bolide
Amount
-53.61
57.29
-34.56
52.68
-46.9
100
-6.3

@binu_acs @usmanbashir@Qiu

 

Expected Output: 
in my end output i would like to remove point and negative sign

the datatype should be Numerical
I have tried different ways , but unable to get the expected output, i have checked the show numerical separator in results also

 

Amount
5361
5729
3456
5268
4690
100
630
binu_acs
21 - Polaris

@BRRLL99 Use ReplaceChar() function

 

image.png

Labels
Top Solution Authors