3

When we run the Contributions and Membership details report for our organization, it reports 41 entries in the month:

Row(s) Listed 41 Total Amount $ 1,320.00(44) Average $ 30.00

However, when the 41 rows are exported as a CSV, the amounts total to $45 less.

What is the meaning of the "(44)" beside the total amount? I suspect it represents that the total is based on 44 rows instead of 41 which would account for why the total is erroneously high.

Is this a "feature" or a "bug"? If a feature, how can I figure out the three extra rows since they do not show up anywhere in the report

Incidentally, if I do the same as a "Find contributions" search, it returns 41 rows and the correct total dollar amount for those 41.


This is version 4.5.8, and the organization has not been using soft credits in its operations.

3

You don't specify the version of CiviCRM you're using? Depending on CiviCRM version, you might be seeing one of these issues -

You could search https://issues.civicrm.org/ for other issues if none of those seems like your case (you'll know if you're using soft credits, contribution fees etc).

If you are seeing the issue on a version of CiviCRM that is marked fixed above, post a message on that issue URL - you may be able to assist by providing some (anonymised) example DB data for the core team.

  • This is now resolved. For some unknown reason a few contact records ended up with two primary addresses (is_primary = 1). Once this was fixed, the report error disappeared. At this point, I have no idea how the underlying civicrm_address table problem occurred. We think it may be associated with merging duplicate contacts but I have not been able to duplicate the situation when I test it. – ldgpangeo Jun 6 '15 at 1:27
  • Good work tracking it down! Suggest reporting that as an issue against the report - at least that will document it for others, and it might even get fixed :) issues.civicrm.org – Chris Burgess Jun 6 '15 at 1:30
  • I've now posted it in the bug tracker. I was hoping to uncover how the duplicate primary addresses were created. Our principal user thinks it may have been caused by merging duplicate contacts, but I've not been able to replicate the situation. I was hoping for more information before submitting it to issues. – ldgpangeo Jun 7 '15 at 2:15
  • That's fine. I think "report does wrong thing when duplicate primary addresses" and "doing X can cause multiple primary addresses" are different bugs, which combined for you (but the report total bug might also affect others who got into the same situation via a different route). Having them in the issue queue helps put them on the radar, and linking between the two means you can continue discussion here if need be. – Chris Burgess Jun 7 '15 at 2:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.