I faced similar issue in some CiviReports where some of the Select attributes applied with Group function like SUM(), got affected due to LEFT JOINs. Let me provide further clarification on basis of two resolved/current CiviCRM issues -
- https://issues.civicrm.org/jira/browse/CRM-16338 where contribution sum(total_amount) got tripled if the contribution is linked with three soft-credits. Although resolved it via splitting the query onto contribution and soft-credit queries respectively, which might not be the right way to do it :/ [civicrm_contribution one-to-many civicrm_contribution_soft]
- https://issues.civicrm.org/jira/browse/CRM-16719 where SUM(duration) got doubled if the activity got two target contacts. [civicrm_activity one-to-many civicrm_activity_contact]