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