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
- 01Name the column exactly as it appears in the sheet: “sum the Overtime_Hrs column”, not “sum the overtime”.
- 02Check the header row is a single row. Merged or stacked headers confuse column detection.
- 03For a filtered question, say the filter explicitly: “sum Amount where Status is Paid”.
- 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?