- Follow the steps in Export of Total Gift Amount is Incorrect in 7.95, patch 1 to export the Total Gift Amount fields
- Once the data is exported from RE, sum the new Total Gift Amount fields using a formula field to get the hard and soft credit total for each constituent
- From the Field Explorer, right-click on Formula Fields and select New
- Enter a name for the formula, for example Hard and Soft Credit Total, and click OK
- From the Field Tree list, double-click on the CnSmryGft_1_Total_Gift_Amount field
- Add the plus sign to the formula
- Double-click on the CnSmryGft_2_Total_Gift_Amount field from the Field Tree list
- Click Save and Close
- Insert the formula into the report
- From the Field Explorer, right-click on Formula Fields and select New
- To get a total of all hard and soft credit gifts for all constituents, insert a summary on the new formula field
- Go to Insert > Summary
- Select the new formula field from the first drop down
- Select Sum from the second drop down
- Leave the third drop down as Grand Total (Report Footer)
- Click OK
- The Grand Total summary field will show up in the Report Footer section
- Go to Insert > Summary
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.