Add Recurring Gift Total Paid field to the revenue query view

In an ad-hoc revenue query in CRM, I would like to include the total amount paid on a recurring gift (Total Paid field which is displayed on the transaction), however it is not available in query builder.

  • Joanna Moran
  • Aug 8 2018
  • Reviewed: Need Further Info
Blackbaud CRM / Query
Organization Name (Please enter full organization name) University of Oxford
Reported Version 4.0
  • Attach files
  • Admin
    Pat Conley commented
    June 12, 2019 13:46

    Have you tried including SUM(Recurring Gift Payments\Amount) in your query?

    Attachments Open full size

Related ideas