Revenue totals can differ due to time zones, refund rules, order states, or refresh windows.
Document each definition, source, date boundary, currency, and refresh time. Trace sample transactions through both models before edits.
Analytics engineering can define shared metrics and lineage. Informatix Systems can assess the symptoms, evidence, and next steps. Contact Informatix Systems to discuss this issue.