I have been searching around and seem to not be able to find someone who had a similar case to what I need.

I have a report with lines like so:
Gift Date          Amount          Type            Gift ID
5/7/10             100                Cash             25456
5/7/10             100                Cash             25456
6/8/10             200                Pledge           25868
6/8/10             200                Pledge           25868
8/30/10           350                Cash             28497
8/30/10           350                Cash             28497

I want a running total that:
(1) Evaluates on change of Gift ID
(2) Only evaluates if Gift type = Cash

I want to make the same kind of running total for "Pledge" and other gift types, so I can have running totals side by side at bottom, i.e.:

Total Cash        Total Pledge            Total Support
450                   200                         650

Any help here?  I don't know how in "use a formula" to enter both of these conditions.

Thanks!

It is not a join problem, and some of the lines are not duplicated.  It cannot be easily fixed.  This is happening because this is from gifts running out of Raiser's Edge, some of which are credited to both spouses, some of which are credited from businesses to two spouses, etc.  There are too many factors to try to eliminate, so it is definitely best to reset it on gift ID.  Thanks though.

DBlank:

Well I did not get an error, but it is not adding correctly.  Not sure if it makes a difference but I actually need: type in ["cash", "pay-cash", etc...]

This is what I have:
Next ({CnPrt_1Gst_1CnGf_1.CnPrt_1Gst_1CnGf_1_Gift_ID})<>{CnPrt_1Gst_1CnGf_1.CnPrt_1Gst_1CnGf_1_Gift_ID} and {CnPrt_1Gst_1CnGf_1.CnPrt_1Gst_1CnGf_1_Type} in ["Cash", "MG Pay-Cash", "Pay-Cash", "Recurring Gift Pay-Cash", "Stock/Property (Sold)"]

Before you sent your reply, I figured out my problem.  First, I think I actually want a Previous formula because I want it to count the first of the duplicates, not the second (this is because, in some cases, one of the duplicate gift IDs shows a gift amount of $0.00).

Now here is my problem: It is not adding the first number, i.e. the one that has no previous value.

How do I include this first gift, or rather, how do I include the first gift that has the correct gift type?

Here is what I have now (I switched it around but it's the same):

{CnPrt_1Gst_1CnGf_1.CnPrt_1Gst_1CnGf_1_Type} in ["Cash", "MG Pay-Cash", "Pay-Cash", "Recurring Gift Pay-Cash", "Stock/Property (Sold)"] and Previous ({CnPrt_1Gst_1CnGf_1.CnPrt_1Gst_1CnGf_1_Gift_ID})<>{CnPrt_1Gst_1CnGf_1.CnPrt_1Gst_1CnGf_1_Gift_ID}


Edited by JFinzel - 22 Aug 2011 at 5:03am

Perfect!  Thank you once again.  Yes, I've noticed changing to default values for nulls often can fix running total issues.