Strange Rounding

[Qiro]

Hi guys,

I have a simple sum that adds up all the values in a column, then a VC takes the total and divides by 7.

In this case, the result is 20.857142...

If I attempt to ROUND() that figure, or force AppSheet to show it without decimal places, it displays the result as 28, not 21.

Any idea what's going on?

[SkrOYC]

Try dividing it by 7.0, just testing