Floor Function Inconsistent

[wcilliers]

Hi Experts,

Can someone please help explaining to me. We have a need to ROUND DOWN to two decimals and the only way I believe is by using the FLOOR functions. However, it seems to be inconsistent. As you can see below, on some of them it actually drops down 1 decimal. In this case it should not change any of these numbers, or am I missing something here?

Thanks,

Wynand

[awhitfield]

Use round instead

[sunny_talwar · Accepted solution]

Something to read:

Rounding Errors

[wcilliers]

I cannot use round, I have to ROUND DOWN. So 1.678 becomes 1.67 and NOT 1.68. This is just example data, and I found some inconsistencies in my actual data and started testing, that is why I posted here.

[wcilliers]

Thanks Sunny,

This is very interesting. I will have a look at some of the workarounds. 

Thanks,

Wynand