AnsweredAssumed Answered

Need Help with Field/Function properties etc.

Question asked by nexxus2k4 on Sep 12, 2009
Latest reply on Sep 18, 2009 by TSGal

Title

Need Help with Field/Function properties etc.

Post

Alright, here's the problem. I'm using the contact management template. I have 40 records and I'm using one of the list layouts. I have a field in the standard layout labled "total amount invested." This field is a sum of each individuals various investments that they have made over time

 

Example: John Doe

Amt1: $75,000 Date: 9/1/09

Amt2: $25,000 Date: 9/2/09

Amt3: $25,000 Date: 9/3/09

Total_Amt_Invested: $125,000 (sum of three previous entries)

 

Susie Q

Amt1: $10,000 Date: 9/1/09

Amt2: $20,000 Date: 9/2/09

Amt3: $20,000 Date: 9/3/09

Total_Amt_Invested: $50,000 (sum of three previous entries)

 

Amt1, Amt2, Amt3 and the corresponding date entries are all individual individual fields. The Total_Amt_Invested field is a sum function of those Amt1 etc. fields.

 

Now on my list layout it looks like this

 

John Doe: $125,000

Susie Q: $50,000

Barbara Walters: $90,000

Herbert Hoover: $60,000

 

Where those amounts are the "Total_Amt_Invested" field for each person

 

Now what I want to do is this: At the bottom of this list I want a field that will sum up the "total_amt_invested" field from each record. So using the above numbers it should put out $325,000 (125k + 50k + 90k + 60k). Essentially adding up the total amount invested by each individual (each individual record) so I get a total amount invested between john, susie, barbara, and hoover.  I cannot for the life of me figure out how to do this. Any help would be much appreciated.

 

Thanks in advance. 

 

-Michael 

Outcomes