I have two objects Test Plan ( Master ) and Test Plan Script ( Detail). Test Plan has 2 roll up summary fields - "Scripts passed" and "Scripts failed" where summary type = count and filter condition = Test Status = Passed, Failed. Test Status is a picklist field on Test Plan Script.
There is another field "Master Test Plan" on Test Plan which is a self look up to same Test plan object.
Roll up summary fields are able to get the count of passed and failed Test plan scripts which are directly linked to their Test plan
Issue is when Master plan has related sub test plans ( sub test plans have test plan scripts ), rollup summary field shows zero passed zero failed even though its sub test plans have some test plan scripts passed and failed.
Can we achieve the cumulative count of test plans scripts passed/failed on the master test plan by creating new formula fields or creating bucket fields in the reports.
I hope my question is not confusing and wanted to know if we can achieve with out apex code.