I have added a Planned % complete column to my project. This works perfectly well for tasks but on milestones it returns 'ERROR'. The reason it is doing this is because the field it is reading from has 'total duration' as 0/ 'Planned to date' as 0... thus
0/0 is causing the error...
The formula is Number2/Number1
is there a way of saying. if the 'total duration' column = 0 then show " " and if its >1 then Number2/Number1
I can figure this out in Excel but its causing a headache in MSP.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.