Enterprise Custom Field Project Forumulas not displaying in Project Center RRS feed

  • Question

  • Hi, I want to show a graphical representation SPI status in Project Center. I'm using the Project level field, not task or resource. When I reference SPI in the formula field, it is blank in Project Center even without the graphical indicators. I added the SPI field in Project Center and the SPI field indicates value. So I tried the following formulas in hopes of using an indicator and still no value is shown in the blank field. I've alternated them between text and numerical valued fields.

    What am I missing?

    [BCWP] / [BCWS] 

    and also

    IIf([BCWP] / [BCWS] < 0.8, "R", (IIf([BCWP] / [BCWS] >= 0.8, "Y", IIf([BCWP] / [BCWS] >= 0.8, "G", ""))))

    Thursday, February 21, 2013 9:11 PM

All replies

  • Hi Dovendaven1, Try to republish your projects via MSP. Hope that fix this issue. Cheers, Badal

    Warm Regards Badal Ratra

    Thursday, February 21, 2013 9:33 PM
  • Assuming the Graphical Indicators table has the values set e.g. R = red, Y = amber, G = green, then ensure the data (budget cost, budget work) you need is in the project, and ensure the plan is published.
    Friday, February 22, 2013 8:57 AM