- From Analysis, Information Library, Select Add an Ad-hoc query > Choose the source view of Revenue
- On the left Expand Application Details > In the middle select Designation system record ID > Move to Include records where and set equal to your designation
- In the middle select application > Move to Include records where and set is one of Donation, Pledge
- On the left select Pledge Payments > In the middle select Amount > Move to Include records where and set is blank
- Output any fields you would like to see in Results fields to display
- Preview your Query
- Save and Close
Connect and collaborate with fellow Blackbaud users.