Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to get TWO decimal places in output

Anjankumar2021
8 - Asteroid

 

input:

-40.11000061
-0.975714266
-0.349124938
-181.6199951
-0.50666666
-0.769999981
-129.1907806
-0.89200002
-1.076666713
-0.725697696
19.31999969
0.330000013
-167.2200012
-0.970000029
-0.649999976
6.369999886
5.880000114
-0.973999977
-0.209999993

 

Required output:

 

-40.11
-0.98
-0.35
-181.62
-0.51
-0.77
-129.19
-0.89
-1.08
-0.73
19.32
0.33
-167.22
-0.97
-0.65
6.37
5.88
-0.97
-0.21
5 REPLIES 5
Bren_Spill2
12 - Quasar
12 - Quasar

@Anjankumar2021 - you can change the data type to FixedDecimal and the size to 19.2 within the select tool

 

image.png

Bren_Spill2
12 - Quasar
12 - Quasar

@Anjankumar2021 - or in a formula tool use: Round([Amount], .01)

Raj
16 - Nebula

@Anjankumar2021 
using formula tool is always a better option as for multiple fields you can use multi field formula.

Formula - Round([Field],0.01)

Anjankumar2021
8 - Asteroid

@Raj  @Bren_Spill2 in the result window i can see decimal places rounded to two like....-40.11 where as when we  check output file still i can see 40.11000061.

 

Please assist.

 

i have applied formula tool : Formula - Round([Field],0.01)

 

Bren_Spill2
12 - Quasar
12 - Quasar

@Anjankumar2021 - can you provide a copy of the workflow? Or a screenshot?

Labels
Top Solution Authors