Very good update of your previous video for the NOW() date. Now you can choose the TODAY date as the Status Date and its gives the same results as in the previous video. Am I correct? Thank you!
Hi Sir, i have used the formula but i realize the planned % of my Group summary rows are not the same as per Actual % despite all sub-task are in the same percentage between Actual vs Planned. By any chance you any idea on this matter?
Hi Firdaus, the reason for seeing the difference is that the actual completion percentage uses a different formula for calculation as compared to the planned completion formula. Since the parameters for both are different, you will see different values