topic ROUND function in App Development

ROUND function

MindaugasBacius — Tue, 17 Jan 2023 07:47:06 GMT

Hei,

How does the ROUND function is working?

I do expect this to turn to 40.2

While this 40.25 - rounds according to my knowledge 🙂

Please anybody explain.

Thank you guys.

Re: ROUND function

tresB — Tue, 17 Jan 2023 08:33:19 GMT

Hi @MindaugasBacius , this is related to binary number system that we should be careful of when dealing with floating point comparisons or so. Read it here : Rounding Errors

Re: ROUND function

MindaugasBacius — Tue, 17 Jan 2023 12:50:00 GMT

I did read the article. And will have to read it 10 times more to digest this way of thinking 🙂

Re: ROUND function

tresB — Wed, 18 Jan 2023 05:06:37 GMT

🙂 - I agree