Microsoft project - Custom Fields error


  • 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. 

    Thanks in Advance


    Friday, March 17, 2017 12:01 PM

All replies

  • Meikle6,

    Sure, try this formula:


    Hope this helps.


    Friday, March 17, 2017 2:27 PM