Evidence and record interpretation

Reconcile conflicting totals in a historical animal-health report

Keep each figure attached to its exact document, version, unit and reporting period. Check whether the figures count the same things before comparing their arithmetic. If the discrepancy remains unresolved, describe it plainly rather than selecting a convenient total or presenting an editorial calculation as an official correction.

Updated 749 words · 4 min read

Name the discrepancy precisely

“The totals disagree” is a starting observation. Make it specific enough for another reader to find: the summary on one page gives a figure, an appendix gives another, and both appear to describe the same period. Record the page, table, row label and document edition for each.

Preserve a permitted copy of the report consulted and its source address. A document with the same title may later be replaced. Keep a file checksum where useful for identifying the exact copy; a checksum identifies bytes and does not establish which figure is scientifically correct.

Compare units before adding numbers

A table of reports, a count of affected premises and a count of animals cannot be added as though they share a unit. Write the noun beside every number. Also retain whether the source labels a figure preliminary, revised, cumulative or limited to a particular reporting window.

Check geography and inclusion rules. A regional appendix may overlap a national summary rather than add to it. Separate tables can describe different subsets, and a total may exclude rows that remain visible for historical context. Use the actual explanatory notes instead of guessing the intended relationship from layout.

Check Possible explanation to examine
Unit Reports compared with animals or premises
Period A monthly table compared with a cumulative figure
Geography Overlapping regional and national coverage
Version A preliminary count compared with a later revision
Identity The same entry listed in more than one section
Eligibility Footnotes describing excluded or provisional rows

Work through a fictional appendix

An illustrative report states a total of eighteen entries. Two appendix sections each contain ten rows. A quick sum produces twenty, which seems to contradict the summary. Inspection of the printed entry identifiers shows that two entries appear in both sections.

The defensible editorial observation is now narrower: there are twenty listed rows and eighteen distinct printed identifiers across those sections. That may explain the apparent difference. It does not establish that the publisher intended the summary to count those identifiers, or that every repeated identifier is an accidental duplicate. Check the report’s definition before calling the reconciliation complete.

If identifiers are absent, do not infer duplicate identity solely because two rows share a locality and a date. Similar descriptions can represent separate entries. Keep the candidate match and its uncertainty in the analysis notes until better evidence resolves it.

Separate transcription errors from source conflicts

Return to the visible original when text extraction produces an unexpected number. A misplaced column, a footnote marker or a line break can change the meaning of an extracted table. Record a correction to the local transcription with the original passage that supports it.

If the disagreement is present in the original itself, label it as a source discrepancy. Do not silently repair it inside quotation marks. A note can state both attributed values and explain that the available document does not resolve the difference. An editor’s proposed explanation belongs in its own sentence.

Keep the calculation inspectable

Save the selected rows, inclusion rule, unit and arithmetic used in any derived figure. For a count of unique records, identify the actual key and how missing or repeated keys were handled. A spreadsheet formula is difficult to interpret if its input rows have been replaced.

Use the local comparison tool to locate structural changes between two record files after selecting a suitable stable identifier. Its difference report can identify edited rows; it does not decide whether a publisher’s historical total or an epidemiological conclusion is correct.

Publish the current explanation and the remaining limit

Write the result in ordinary language. For example: “The summary gives eighteen entries; the appendix lists twenty rows, including two repeated printed identifiers.” Add the document citation and the unresolved definition if it remains material. Avoid reducing the account to a single unlabeled number in a chart.

If an authoritative correction is later located, identify the changed statement, the correcting document and when the correction entered this site. Review any dependent graph, download and opening answer together. Use the timeline correction guide and citation guide to preserve that trail. An explicit unresolved discrepancy is more useful than an apparently exact total whose meaning cannot be reconstructed.

Cite this reference

LivestockDefense. “Reconcile conflicting totals in a historical animal-health report.” Updated 2026-10-29. https://livestockdefense.com/guides/a-historical-animal-outbreak-report-with-contradictory-totals/

Add the date you accessed the page. This identifies the current reference; keep a permitted saved copy if your work depends on its exact wording. A citation alone does not establish support for a claim.

How to cite a page and its revision ↗