I am looking for any suggestions on a slight modification to the Detailed Project Portfolio dashboard. I am looking for a better way to report % Complete on a project as a way to measure Project Performance. What I would really like to be able to do is calculate Schedule Performance Index (SPI) using the data that is available within the Portfolio Dashboard and then determine if the Project is Red, Yellow, Green (ie SPI above .9 would be Green, between .9 - .8 would be Yellow and anything below .8 would be Red).
I just can't seem to wrap my brain aroudn the formula....
Any thoughts, suggestions, comments are welcomed.
I just can't seem to wrap my brain aroudn the formula....
Any thoughts, suggestions, comments are welcomed.