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.

  • Jo Moran
  • Aug 8 2018
  • Reviewed: Need Further Info
Organization Name (Please enter full organization name) University of Oxford
Reported Version 4.0
  • Attach files
  • Admin
    Pat Conley commented
    12 Jun, 2019 01:46pm

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