Error: Project details table visual within the Project-Status layout was incorrectly showing aggregate of all tasks (including summary tasks) for the selected project.

Fixed: Replaced the task fields with equivalent project fields (the project fields are calculated by the scheduling engine and do not include summary tasks in their calculation).

Fields added to the Projects table:

Updated the SchedulerQuery:

, p.[tpg_effort] AS [Forecast Effort]

, (p.[tpg_effort] * (p.[tpg_progress] / 100)) AS [Actual Effort]

, (p.[tpg_effort] - (p.[tpg_effort] * (p.[tpg_progress] / 100))) AS [Remaining Effort]

Updated the PlannerQuery:

, p.[msdyn_effort] AS [Forecast Effort]

, p.[msdyn_effortcompleted] AS [Actual Effort]

, p.[msdyn_effortremaining] AS [Remaining Effort]

Fields replaced in Project-Status layout:

Additionally, filtered the Project-Effort layout where 'Tasks'[Is Summary] = "False"; and added a title of "Forecast/Actual Effort By Task Start Date" to clarify how the monthly values are determined as this can be confusing to report viewers (in cases where task durations span multiple months)