Pivot table sums (avg) Non-Integer Column create incorrect outcom

[SY]

Why Access Pivot table sums or averages Non-Integer Column would first round
the decimals to integers, then does the calculation on the rounded number to
create incorrect outcomes?

Is there a way to fix this beheavior of Access ?