RE query in database view does not correctly process records when using Tools>Query Options>Gift Processing>Credit Soft Credits to: Recipient 'Use Amount in Grid'.

For any one gift, if there are multiple soft credited individuals, it is supposed to use the amount each soft credit donor is responsible for and put this as the Gift Amount and the soft credit donor's name as the Constituent Name. Export does this just fine.

Query does not do this, rather, it puts each soft credit donor as the Constituent Name with the total soft credit amounts combined as the Gift Amount. This skews giving data from query significantly.

For ex: I have a gift of $1,000 with 3 soft credit donors. Each donor is soft credited for a different portion of the gift's total.

Donor A - soft credited for 500

Donor B - soft credited for 100

Donor C - soft credited for 400

I would expect if I select "Use amount in grid" as the query processing, to see 3 output lines - a line for each donor and their Gift Amount as 500, 100, & 400, respectively.

What query currently does it 3 output lines - a line for each donor, BUT the Gift Amount is 1000, 1000, & 1000.

If I report on Gift Amount, then my original $1,000 gift has now become $3,000.