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_Spill
12 - Quasar

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

 

image.png

Bren_Spill
12 - Quasar

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

Raj
15 - Aurora

@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_Spill 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_Spill
12 - Quasar

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

Labels