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},{Gif t.Code}."V erbal") 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 ???
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},{Gif
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help
ASKER
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 !!!!!