Earned Value Error

[Jeff]

I wonder if anyone can assist me with this problem?

I'm evaluating the use of the earned value performance indicators and
discovered that if BAC, BCWP and ACWP are all equal non-zero values the
resultant TCPI value is a spurious "4294967295"??

Is there a known problem here, and a known work-around?

Jeff

 

[Brian K - Project MVP]

I wonder if anyone can assist me with this problem?

I'm evaluating the use of the earned value performance indicators and
discovered that if BAC, BCWP and ACWP are all equal non-zero values
the resultant TCPI value is a spurious "4294967295"??

Is there a known problem here, and a known work-around?

Jeff

The one time I was able to replicate this the values were not all zeros
but setting the status date to a date sometime after the first actual
work was done on the task fixed this.

The issue might be a divide by zero issue since the formula for TCPI is:
TCPI = (BAC - BCWP) / (BAC - ACWP)
and if both BAC and ACWP are equal then this formula would result in a
div by 0 error. Perhapes this odd number you are seeing is what is
displayed in this case.

Try changing your status date to something realistic.

 

[Jeff]

Thanks for that, but it didn't work. The status date was aleady set for
something realistic. (This project started last year, and the status date is
as of end Jun 03. Still, I tried a few different status dates but no luck).

As for the divide by zero suggestion, it is partly that although if all
values (BAC, BCWP and ACWP) are zero, the result in the TCPI is a zero too??

My current work around is to use a number field and use the formula for TCPI
in that. Seems to work, but it is a shame I can't trust the field that is
provided!