1

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

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

1 Answer 1

Reset to default
3

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

Improve this answer
1
  • 1
    Comments are not for extended discussion; this conversation has been moved to chat.
    – Adrian Larson ♦
    Commented Jan 5, 2018 at 15:36

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .