Rounding up to 4 decimal places

Question

Hi, currently I am working with pricing data and I want to round the numbers up to 4 decimal places as Excel usually do. (Rounding up if we have 5 or more than 5 and round down if we have a number less than 5)

I used Round([Field1], 0.0001) formula but it doesn't do the justice to all the record. (for some it rounds up and for some it rounds down, not consistent). I have attached a workflow as well. I really appreciate your ideas/ suggestions on this.

test.yxmd

Nathashawije · Answer

Thanks all. I really appreciate your responses.
I actually used the dirty trick, it was not the best (still there are rounding up and down issues, Alteryx still hasn't the capability to do that correct) but I could convince my manager. He is okay with having a tiny difference on the numbers.

AngelosPachis · Answer

Oh that's a nice one as well. Still in my head the "dirty" way still seems easier to explain to a third person for some reason 🤷‍

philipmannering · Answer

Thanks @AngelosPachis.

Just realized, a less dirty solution might be just giving your digits enough precision,