% Complete Today Vs Actual % Complete
Hi,Does any one know if there is any calculations which says % Complete date as on TODAY by calculating Planned start, Planned finish and “current date”. (lets call it % Complete Today)
I was looking for a formula which gives below calculations. (I’m comparing it with actual % Complete)
[% Complete Today VS Actual % Complete]
Below is the scenario.
If % Complete Today is less than or equal to actual % , then Green
If % Complete Today is greater than actual % it is Yellow.
For "Red" If % Complete Today is greater than Actual% and same for Yellow but with a 10% extra to differentiate between yellow and red.
It will be really helpful if any one can get a formula.