+ Start a Discussion
Siddharth LakhotiaSiddharth Lakhotia 

Trigger to summarize value of a field?


I have 2 objects Object A and Object B

Object B has a lookup to object A.

Object A has three fields  Aname , BNmber and ASales

Bnumber is a code and can have several values against it.

Bnumber 123        ASales 100

Bnumber 123        ASales 300

Bnumber 123        ASales 500

I need help in writting trigger on object B, that pulls sum of Asales against Bnumber ( 900 against 123 in this case) 

The sum of Asales against Bnumber should be stored in a field on Object B...

Post that I can rollup this object to Opportunity(master) and then the actual sales will appear on the opportunity
Hi Siddharth,
As per your requirement you want sum of Object A Sales on Object B.
for this you can create a rollup field on Object B on Object A Sales.
Siddharth LakhotiaSiddharth Lakhotia
It's a lookup relationship.. I cannot have a roll up summary for it.. also , I need sum of Asales against a comman Bnumber Let's say.. if Bnumber in different records is command but the value is different as mentioned in the question. Also since this object itself has a master detail relationship to another opportunity object..
Siddharth LakhotiaSiddharth Lakhotia
Can anyone help a bit on this one