Solicitor Performance Analysis Over(Under) numbers aren't calculating correctly

When working with the Solicitor Performance Analysis, the reports columns aren't adding up correctly, specifically the Over(Under) column does not total up as the other columns would suggest. 
This can occur if a solicitor has multiple goals (for multiple Campaigns, Funds, or Appeals), because the amount over or under for each separate goal is added together to reach a summarized Over(Under) amount. 

For example, Mary Young has the following goals:
  • $2,000 for the Annual Fund
  • $1,000 for the Capital Campaign
She has also solicited the following gifts:
  • $300 gift to the Capital Campaign
  • $2,000 gift to the Capital Campaign
  • No gifts to the Annual Fund
When I run the Solicitor Performance Analysis for Mary Young, she will be $1,300 over her goal for the Capital Campaign, and $2,000 under for the Annual Fund. In a summarized report, her Over (Under) will display as ($700). 

Steps to Duplicate

  1. Open the Raiser's Edge
  2. Navigate to Reports > Analytical Reports > Solicitor Performance Analysis and create a new report
  3. Select to report out in Summary
  4. Add solicitors 
  5. Preview report 
  6. Over(Under) doesn't add previous columns correctly

Amount raised: $68,705.00
Goal: $166,000.00
Over(Under): ($65,615.00) when it should be ($97,295.00)

Solicitor Performance Analysis example

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.