I've been trying to count how many milestones called "Testing" with %Complete = 100% are per project. Each milestone is a child of a parent called "Milestone" and this is at the same time a child of the project name. At the end, each project is a child of a big project name. (I've attached an example of the structure).
I have read others comments and documentation of the hierarchical formulas, however, it's not clear to me how to develop it correctly.
If someone can help me to elaborate it, I'll appreciate it a lot. I'm learning in the process.