Hey All,
I've read a couple of really old forum posts about a custom view that includes contributions and credited contributions to use for custom list criteria and output set elements. Does anyone have updated SQL for that view they could share with me?
I'd like to create new total giving elements that include soft credits and exclude a couple of our campaigns and I'd love to have something to build off of rather than starting from scratch!
Thanks,
Dorothy
Hi Dorothy,
I'm not sure about the SQL for the custom view, but there's a standard report in the Development folder that I use called "Current Constituent Giving by List". It outputs total giving & soft credits based on a list. Sorry that doesn't answer your question directly, but I hope it's helpful in the meantime!
Thank you!