Gifts that are split between multiple campaigns, funds and appeals within Raiser's Edge are not showing with the correct amounts within the Crystal Report when trying to report on the breakdown of amounts by campaign and fund.
When exporting the split gifts amount via the Campaign > Campaign Amount, Fund > Fund Amount, or Appeal > Appeal Amount, the value that is exported within these fields are strictly the amount of the split that is accredited to the specific Campaigns, Funds, and Appeals. It does not link the amounts to a particular combination of Campaigns, Funds, and Appeals - just the overall amount that has been listed towards the listed Campaign, Fund, or Appeal.
For example, let's say you have a gift that is split as follows:
Gift Date Gift Amount Campaign Fund Appeal Split Amount 1/1/2010 $100.00 Campaign-1 Fund-A Appeal-1 $50 Campaign-1 Fund-A Appeal-2 $35 Campaign-1 Fund-B Appeal-1 $15
When you export this gift, and the Campaign > Campaign Amount, Fund > Fund Amount, and Appeal > Appeal Amount, the different amounts are going to be exported as follows for this particular gift:
As you can see, your grand total is double your actual gift. The only way to get the correct amounts to export for gifts that are split between a combination of Campaigns, Funds, and Appeals are to enter each complicated split as a separate gift.