Why do rounded FPL figures fail to add up exactly?

Xiao K · FFTQL developer ·

Rounding individual entries before adding can differ from adding full-precision values and rounding the total.

FFTQL data states, timestamps and source policy

Keep calculation precision separate from display

Two hypothetical values of 1.4 each become 1 and 1 when rounded separately, summing to 2. Their unrounded sum is 2.8, which rounds to 3. Retain source precision in the working sheet and state the display rule when presenting the result.

Check units as well as decimal places. A tidy-looking table can still mislead if one field is a proportion and another is a points value without a clear heading.

Practical checks

  1. Keep the raw values and formulas.
  2. Document the rounding order and display precision.

Context and sources

All numerical examples are hypothetical. The formulas explain a method, and the linked product pages explain data context. For real analysis, retain the source, units, season, gameweek range and retrieval time so another reader can reproduce it.

Sources and useful pages