Checks to run
- Are periods identical or comparable?
- Are key columns present in both files?
- Are export filters the same?
- Does file B include A or is it another scope?
Comparability
Why are two sales exports not always comparable?
Two files can be readable on their own and still be hard to compare. The issue often comes from a different period, an export filter, a missing column or a changed scope.
In short
This question prevents false conclusions: growth can come from the business, but also from a longer file, another source or a forgotten filter.
Simple method
What to check
Warning signs
- Overlapping periods.
- Very different durations.
- A rows not found in B even though B is supposed to be cumulative.
- Different amount, date or customer columns.
RGAnalyzer
What RGAnalyzer helps surface
RGAnalyzer shows what the file can support and flags limits that may change the conclusion.
1
Detected period in each file.
2
Difference in usable rows.
3
Recommended mode when the selected mode does not fit.
4
Careful reading rather than overconfident scoring.
FAQ
Frequently asked questions
Can a clean file be poorly compared?
Yes. Technical quality can be good while the comparison mode is wrong.
Should the report be blocked when files differ?
No. It should show limits and avoid strong conclusions.
What is the best reflex?
Check period, columns and scope before interpreting differences.