Forum Discussion
Marius350
May 03, 2023Copper Contributor
Help needed on MS Projects.
Hi Guys, Can you please assist me on the following. I cannot find the problem. On my MS Projects Schedule I have the following: % Planned and % Complete Now here is the thing. I ca...
- May 10, 2023
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
Marius350
May 18, 2023Copper Contributor
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?
John-project
May 18, 2023Silver Contributor
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