none
Microsoft project - Custom Fields error

    Question

  • 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

    Meikle6

    Friday, March 17, 2017 12:01 PM

All replies

  • Meikle6,

    Sure, try this formula:

    IIf([Duration]=0,"",[Number1]/[Number2])

    Hope this helps.

    John

    Friday, March 17, 2017 2:27 PM