Hello, I have a fixed decimal field that I've used the select tool to convert to double. I want to round these values to the nearest whole number, so I then used a formula tool and tried creating a new field for the rounded value (field type double) and using the following formula: Round([Field 1], 0), but the output is still an unrounded number. I tried this with another field that follows the same scenario (fixed decimal, converted to double), and records that once had values now show NULL.
Can anyone help me troubleshoot this?