Forum Discussion
Why aren't some Tasks displaying Custom Field Graphical Indicators
I created 2 custom fields called Cost KPI and Schedule KPI that use the value of the SPI and CPI fields to display graphical indicator colors depending on the value of the SPI or CPI fields. For some reason though I have some tasks that for some reason are not displaying a graphical indicator as shown in the below screenshot and I can't figure out why. What is causing this and how do I fix it? Any ideas?
Actually I changed my test criteria to be as shown below and now all of the rows are reflecting a graphical indicator. So it was something related to how my test criteria were defined.
14 Replies
- Hello John.
The result of EV/AC=CPI, of the tasks without graphic indicator is 0.999, and this value does not belong to any of the criteria of the costKPI custom field.
RegardsIgnacio_Martin so I need to modify my criteria range to be 0.00-0.999. It seemed project was only generating cpi and spi values to 2 decimal places. I will update the is within range criteria and see if that resolves it.
Ignacio_Martin Where are you seeing the CPI as a value of 0.999. As you can see in the screenshot below, the CPI value is 1 not 0.999.
John,
Try this, switch your custom field "data to display" from graphical indicators to "data". You may find the "data" shows #ERROR. If so, resolve that problem. However, if the data seems correct, what is the formula in your custom field?
JohnJohn-project The formula is simple. For cost KPI formula = CPI. For Schedule KPI, formula = SPI. When I changed the display from graphical indicator to data. There was no error. The CPI value displayed.
John,
I notice the custom field for your Schedule KPI shows indicators for all task lines but the custom field for Cost KPI is missing indicators for a summary line and a task line. What are the custom fields for each (e.g. TextX, NumberX, etc.)?
Try changing to a different custom field for the Cost KPI. Is the indicator still missing from those lines?
John
