Link to home
Start Free TrialLog in
Avatar of LosJee
LosJee

asked on

Need Help with Sum(fld, condFld, cond)

Hi,

I'm pretty new with CR8.5 put I still know a little bit how to use it...

I have a list of Donors and a list of Pledges.

1 Donor can have many pledges.

Here's how my DB looks like :

DONOR       TYPE          CODE         AMOUNT
Donor1       Pledge        Verbal         1000
Donor1       Pledge        PG               5000
Donor1       Pledge        Verbal         2000
Donor1       Pledge                          4000
Donor2       Pledge        Verbal         3000
Donor3       Pledge                          1000
Donor3       Pledge                          2000
...

I would like to have a formula that would add the amounts depending of the Code for each donors.

My understanding is that : SUM({Gift.GiftAmount},{Gift.Code}."Verbal") should work but it doesn't.....

I'm trying to do a formula that would SUM the amount of all the pledges with the same codes for each donors....
Regular Pledges have no codes.

So my result should look like :


Donor1      TotalVerbal        TotalPG       TotalRegular
Donor2      TotalVerbal        TotalPG       TotalRegular
Donor3      TotalVerbal        TotalPG       TotalRegular

Can anybody help me ???
ASKER CERTIFIED SOLUTION
Avatar of ebolek
ebolek

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LosJee
LosJee

ASKER

Thank you all !

My problem was a way more complicated than explained but with your help, I was able to do this with groups but also, with some formula fields...

Thanks again !

U guys are the best !!!!!
Glad to help