input:
Required output:
@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?
