Skip to content

A spreadsheet total looks wrong

Short answer

Totals, averages and maximums are computed over every row rather than guessed by the model, so a wrong figure usually means the column was misidentified — name the column exactly.

Why this happens

Aggregates are calculated, not generated, which is why they are reliable when the right column is used. The failure mode is column selection: merged headers, units in the header row, or two columns with similar names.

What to do

  1. 01Name the column exactly as it appears in the sheet: “sum the Overtime_Hrs column”, not “sum the overtime”.
  2. 02Check the header row is a single row. Merged or stacked headers confuse column detection.
  3. 03For a filtered question, say the filter explicitly: “sum Amount where Status is Paid”.
  4. 04Comparisons between rows are generated rather than computed, and small models make comparison errors. Verify the ones that matter.

Other ways people ask this

  • nightjar spreadsheet total looks wrong
  • Nightjar Browser: spreadsheet total looks wrong. How do I fix it?

Related