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 |
Solved! Go to Solution.
@Anjankumar2021 - you can change the data type to FixedDecimal and the size to 19.2 within the select tool
@Anjankumar2021 - or in a formula tool use: Round([Amount], .01)
@Anjankumar2021
using formula tool is always a better option as for multiple fields you can use multi field formula.
Formula - Round([Field],0.01)
@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)
@Anjankumar2021 - can you provide a copy of the workflow? Or a screenshot?