Campaign Giving Comparison query

Martin Keen (Past Member) $organization over 10 years ago

Folks,

I'm running the Campaign Giving Comparison report comparing the 2014 End of Financial Year campaign against the 2015 EOFY campaign. Group and Compare parameter set to Fund, Show Const Detail = Yes, Group by Household = Yes and Filter Giving = Gave to Group2, but not Group1.

I'm finding that a few households are being included with a curious, negative balance figure being displayed - the attached screenshot displays an example. In this example, there is a contribution to the 2014 EOFY campaign attached to the household record and a contribution to the 2015 EOFY campaign attached to Pamela Broads record.

I can't work out:

why these records are being displayed - shouldn't they be excluded?
what the value of the negative value is made up of - it doesn't relate to the value of contributions associated with the two constituent records and the same value is displayed against all the records in this situation

Can anyone help me decipher this conundrum?

Martin

[edited by: Martin Keen at 11:26 PM (GMT -6) on 5 Apr 2016]

Terry Stevens $organization over 10 years ago

Martin,

I think that is the variance column which would mean that they gave that amount in one year but not the other. I must say I have found strange results with this report when I select "Group by Household". If what you are seeing is not correct try running it without grouping by household and see what you get.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Martin Keen (Past Member) $organization over 10 years ago in reply to Terry Stevens

Thanks for the reply Terry but this doesn't help me I'm afraid!

Running the report without grouping by household returns the record for Miss Broad (without reference to the household) - which is misleading (in our eyes, anyway) as neither Miss Broad or the Household should be returned in the report at all.

Maybe it's time to get a TASK ticket opened?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel