So I have 2 formulas written trying to find the total for 2 different constituent groups in CR. The first formula works fine, but the 2nd gives me the same # and it shouldn't. Any ideas why this might be happening and/or how to fix it?

 

Here are the two formulas I"m using.

 

if {GfCnBio.GfCnBio_Constit_Code} = "Indiv" then SUM ({@MTD_Only})

 

That one works correctly.

 

Then I used this one to get the sum for that month (MTD_Only) for those coded as Major Donors. I tried the following 3 formulas. Each one gives me the same # as the above formula, which is definitely not right:

 

if {GfCnBio.GfCnBio_Constit_Code}  <>  "Indiv" then SUM ({@MTD_Only}) else 0

 

if {GfCnBio.GfCnBio_Constit_Code}  =  "Major Donor" then SUM ({@MTD_Only}) else 0

 

 

I have a formula set up so that I can see the month to date total from a list of YTD gifts (well last month's). That formula is:

 

if {Gf.Gf_Date} in LastFullMonth then {GfFnds_1.GfFnds_1_Amount} else 0

 

and then I have the SUM of that formula and that gives me the amount of giving for that particular month for all constituents.

I need to separate out the 2 constituent codes, though, so I can see the month to date giving for each one separately.

 

Basedon what you just said I tried this, but then I get $0.00 which also isn't right...

 

if {Gf.Gf_Date} in LastFullMonth and {GfCnBio.GfCnBio_Constit_Code} = "Indiv" then {GfFnds_1.GfFnds_1_Amount} else 0

 

So I've got the 2 formulas now summing each const. code. totals for the month.

 

Is there a way to place them both in the same spot, and suppress one on the first page and the other on the 2nd page? That's the last thing I need to figure out, but if not it's no big deal, I'll just create 2 lines.

 

Thank you!