People

Giving Change Fund

This SQL script allows you to specify a Fund ID# and will look at two time periods:

  • The first period will be starting at 365 * 2 or 730 days ago through 365 days ago.

  • The second period will be starting 365 days ago through today.

The report is basically the same as the Giving Change report with the exception of your specifying just one fund. This will show those that have stopped giving, decreased their giving, increased their giving, and those that have just started giving.

See also

Giving Change

Copy the code below and paste it into a Special Content file in your database. We suggest you name the file GivingChangeFund.

After you run the report for the first time you can click Add to Menu and the report will display on the blue Toolbar under the code icon on Search Builder, an Organization, or a Tag. When running from Search Builder you can add any other Conditions to narrow the focus.

Note

In the script below, the fund ID is 1. Replace that with whatever fund in your database that you want to use in the report.

See How to create a SQL Script.

Sample Report

https://i.tpsdb.com/2017-09-24_20-41-56-1.png 
--Roles=Finance
DECLARE @fundid INT = 1     -- put your fundid here

SELECT FundName ,
      gc.PeopleId ,
      TotalPeriod1 ,
      TotalPeriod2 ,
      PctChange ,
      Change
FROM dbo.GivingChangeFund(365, @fundid) gc
JOIN dbo.People p ON p.PeopleId = gc.PeopleId
JOIN dbo.TagPerson tp ON tp.PeopleId = p.PeopleId
WHERE tp.Id = @qtagid
ORDER BY gc.PctChange


Latest Update

10/20/2020

Modify image link with secure protocol.