Forum Discussion
Help needed on MS Projects.
Here is a sample plan with a group of milestones under a summary line. The Number1 field is customized with the formula shown. The summary line is set to sum up the number of completed milestones.
Hope this helps.
John
John-project
Thank You so much for your explanation. Do you perhaps know of a formula I can use just for testing purposes?
Here is a sample plan with a group of milestones under a summary line. The Number1 field is customized with the formula shown. The summary line is set to sum up the number of completed milestones.
Hope this helps.
John
John-project Thank You so much. I have tried the formula on myside but it still give me a syntax error. I also tried to retype it again but it still give me a syntax error.
Can you please assist?
I would help if you would post your formula. However, it may be as simple as changing the delimiter, which is a comma on my system, with a semicolon, which may be the delimiter on your system. For example, try this syntax:
IIf([Milestone]=True And [% complete]=100;1;0)
John