+ Start a Discussion
jisaacjisaac 

formula to SUM the Total Contract Value of attached (lookup child) opportunities

We use a lookup  (parent/child) relationship on opportunities that are "attached" to other opportunities. I need to have a formula field on the Parent Opp that sums a currency field (Total Contract Value) from each of the Child Opportunities.

 

The child opportunities are not Custom Objects so it appears that Roll-up summaries will not work.

 

Can someone help me here?

 

Thanks,

Jane

Best Answer chosen by Admin (Salesforce Developers) 
jisaacjisaac
It turns out we needed to build a trigger to make this work as it acnnot be done with the formulas.

All Answers

jisaacjisaac
It turns out we needed to build a trigger to make this work as it acnnot be done with the formulas.
This was selected as the best answer
RRC007RRC007

Hi. Am running into the same issue. could you share what you ended up doing?

Thanks,

RRC

jisaacjisaac
I will ask my Developer for that so I can post it. Check back later.
priyaroypriyaroy

yes triggers