We have 3 objects Obj A,Obj B & Obj C. Obj C has Master Detail Relationship with Obj B & Obj B has Master Detail Relationship with obj A.

Obj A is the Grand Parent Object of Obj C.

What I want is to get the Count of Obj C records and display the count on Grand Parent Obj A.

Problem is I can not solve this requirement by writing an apex code as all of these 3 objects are Managed Package Custom object and I don't have access of their apex classes & Triggers.

I tried to write Process Builder but can not Use Count Function.

Can someone please tell me how can I get the count using config way or best way?

Screenshot during discussion:

Details on Parent Record: enter image description here

Count Displayed: enter image description here

Rollup summery on Obj B:

enter image description here

Rollup Summery on Obj A:

enter image description here

  • Why dont you make your own apex classes/triggers to do calculations?
    – kurunve
    Jan 5 '18 at 10:51
  • are u talking about creating an apex class using @invocable method and call it in process builder? Jan 5 '18 at 10:53

You can achieve this by doing following steps

  1. create a rollup-summary field on obj B and Count Obj C records

  2. create another rollup-summary field on Obj A and sum Obj B field you created in step 1.

  3. Put that field you created on Obj A in step - 2

Example (Account > Opportunity > Opportunity Product )

Opportunity to Opportunity Product rollup enter image description here

Account to Opportunity rollup enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.