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

@binuacs @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
binuacs
21 - Polaris

@BRRLL99 Use ReplaceChar() function

 

image.png

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels