I am not sure if this a bug or not, but thought i would post it and find out.
I have the following scenario on my projects:
Parent I
Project A1
Milestone A1
Task A1.1
Task A1.2
Task A1.3
Milestone A2
Task A2.1
Task A2.2
Project B1
Milestone B1
Task B1.1
Task B1.2
Milestone B2
Task B2.1
Task B2.2
I am creating a report with the following parameters:
Report on: Task
Include Data: Project and Parent Project
Filter: Tasks which are part of parent project "Parent I"
I am trying to create report highlight which gives me a count of the projects under Parent I. Every formula i try only gives me a count of the Tasks.
No matter which formula i try, the answer is always 9 (when i am looking for 2).
1. Numeric count of $Project.Name = 9
2. Display of $ParentProject.C_NumofActiveSubProjects = 9
Why does it keep counting the Tasks and not giving me an accurate count of the projects which belong to Parent I?