Rounding down by default

[zachritter00]

I have a formula tool that has a round in it but it's rounding down.  It looks like this:

Round([value], 0.01)

where the value is 17.635, and it's giving me 17.36 instead of rounding up to 17.37.

[alexnajm]

You can use the CEIL/FLOOR function to change those roundings for those with the 0.005 value: https://help.alteryx.com/current/en/designer/functions/math-functions.html#idp378968

[zachritter00]

That would help for an individual value, but if I have a lot flowing through the tool, it looks like ceiling and floor force it to round up or down based on the multiple.  i.e., CEIL(17.365, .01) gives me 17.37, but CEIL(17.361, .01) also gives me 17.37, which is incorrect.

Is there a reason it rounds down instead of up?

[alexnajm · Accepted solution]

It does force it up/down based on the multiple you set, but that's why I am recommending setting up some logic so that it only rounds up/down in the instances you want - i.e. those ending with the 0.005. an IF statement could accomplish this

I am not sure why it rounds down instead of up, maybe the data is displaying with the 5 but is really something like 17.364999999

[zachritter00]

Yeah, I haven't been able to figure hat out either after searching.  I found one site that said it was using "banker's rounding" by default, but I haven't ben able to confirm it.

An IF statement would probably fix it, thanks.  Just wish I knew why it does that.