PCP Summary Report show incorrect goal total

The PCP Summary report uses a single query to total the total donors, total committed, total received and total goal.

It uses INNER JOIN to create a query of all the contributions made (which means more than one contribution per PCP record). This means that the total donors, total committed and total received is accurate.

However, since there is more than one row returned per PCP record and the goal amount is stored in the PCP table, the sum of the goal is too high if you have more than one contribution assigned to a PCP row.