My export has subtotal rows mixed in with the data
The file has real rows, but also rows that are section headings with one cell filled, subtotal rows with a figure and no product, and a grand total at the bottom.
Why it happens
- The file is a report rather than a table.
- Double counting follows directly.
- The rows are hard to find by rule because they are defined by what they are missing.
- Asking for the underlying data usually works and is usually not tried.
What to do now
- Ask for the raw export rather than the formatted report.
- Check the total before and after removing summary rows.
- Filter on the identifying column rather than on the amount.
Next time
Rows can be dropped out of both validation and the export, so subtotals, headings, and the grand total are excluded as what they are rather than deleted out of the source file you were sent.
Start from the invoice line items template.
Related problems
My website column will not work as linksA column of company websites contains a mixture of forms: some with https://, some starting www, some bare domains, and a few entries that are not addresses at all.Excel changed the dates when I opened the CSVYou opened a CSV, and dates that read one way in the file now read another way on screen.My SKUs turned into scientific notationA column of product codes, barcodes, or order numbers now reads 1.24E+11.The leading zeros disappeared from my spreadsheetProduct codes, zip codes, or account numbers that started with one or more zeros now start with a digit. 00123 is 123, and 07030 is 7030.