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_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)
@Anjankumar2021 - can you provide a copy of the workflow? Or a screenshot?

