Hi all,
I am facing an issue that has me stumped -
When I have baseline A assigned to a progressed schedule, I am unable to get the Planned Value Cost column in my Activity Table (LHS) to match with the Cum Planned Value Cost column in the Activity Usage Spreadsheet (RHS) at any given data date. This is an issue because our financial and physical S-Curves in Excel were created using the Cum Planned Value Cost values from the Activity Usage Spreasheet (RHS). Normally in our reports we submit both the curves and the P6 activity table printout which includes schedule % complete. So as you can imagine, the schedule % complete differs for the curve and P6 activity table.
Even more perplexing is that the LHS and RHS costs match when the schedule is imported to a SQLite database, but differs in an SQL database (non-server). This behavior is consistent across different machines.
Has anyone encountered this issue before and what are possible ways to resolve it?
Thanks,