We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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