Depending on how CPI (Cost Performance Index) is calculated, there can be different values for the same project. A configurable field on the project profile that uses the CPCALC_ProjectCPI stored procedure uses the following:
- BAC - Planned instead of BAC - Budget
- Actual/(Actual+Remaining) for Percent Complete, instead of Actual/Planned
- AC for actual cost
The calculation is done in the following line of the stored procedure:
(pc.allPlannedCost * (p.ActualHours / (p.ActualHours + p.RollupRemainingHours)))/pc.ToDateActualCost
The Project earned value report from the Cognos Accelerator Reports package uses BAC - Budget and Actual/Planned. You can change the stored procedure to use either of the following lines, and decide which one to keep:
-
(pc.allbudgetcost * (p.ActualHours / (p.ActualHours + p.RollupRemainingHours)))/pc.ToDateActualCost
-
(pc.allbudgetcost * (p.ActualHours / (p.PlannedHours)))/pc.ToDateActualCost