How to Find Receipt Amount = Gift Amount

Ashley Dubash

Our team wants to look at data related to only fully receptible gifts. This would suppress gifts were the door received a benefit such as event related (like gala tickets) or gaming (like raffle).

I thought perhaps querying where the amount given and the amount receipted were equal would be a great way to go about it in one swoop.
Make a query where Receipt amount and Gift amount are equal, make it dynamic and not worry about it again during each export…but I'm not seeing a way to go about it.
Has anyone gone about this?
Or is it easier to make an query based on package and just exclude things related to events one by one

Alan French

@Ashley Dubash unfortunately I don't think there is a way to directly compare the value of one field with the value in another.

We don't use the receipting function but if the scenario is exactly as you describe, that you just want to exclude all gifts with benefits, you could try specifying “Benefit blank” in the criteria.

Mark Guncheon

@Ashley Dubash Not sure if this can be done within query/export but if you include receipt amount with gift amount in export, you can easily remove those gifts in your spreadsheet.