Help Please: Milestone RAG based on total slack - My formula isn't working RRS feed

  • Question

  • IIf([% Complete]<100,switch(([Finish Variance])<=0,"Green",([Finish Variance])>0 And [Total Slack]>5,"Yellow",([Finish Variance])>0 And [Total Slack]<=0,"Red"),"Complete")

    We have built in a Milestone RAG Custom field using the above formula, but for some reason it is only picking up delayed Milestones with 0 days total slack as Red.

    I need for it to pick up Milestones that have finish variance greater than 0 & Total Slack between 0 & 5 

    Any help would be very much appreciated!!! :)

    Thursday, August 8, 2013 4:03 AM

All replies

  • Hi,

    I'm not sure but I think the >5 willl be interpreted as >5 minutes. Can this explain?

    Best use 5*[Minutes per day]


    Thursday, August 8, 2013 7:20 AM