Jul 12 2022 02:49 PM
Jul 12 2022 02:49 PM
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?
Jul 12 2022 03:17 PM - edited Jul 12 2022 03:19 PM
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?
Jul 12 2022 03:36 PM
@John-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.
Jul 12 2022 03:43 PM - edited Jul 12 2022 03:44 PM
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?
Jul 12 2022 03:52 PM
@John-project I'm using the Number2 for Cost KPI and Number3 for Schedule KPI. I deleted the cost kpi custom field and was going to try and use the Number4 field, but now I'm getting an error when I try to rename the custom field to "Cost KPI" saying that the field name already exists. Not sure how it can since I deleted it.
Jul 12 2022 03:59 PM
Jul 12 2022 04:04 PM - edited Jul 12 2022 04:07 PM
@John-project I managed to get the graphical indicator field displaying on the project summary row by changing the options in the indicator criteria for.... to Project Summary. However, I tried doing the same thing by selecting to apply the options for Summary rows and non-summary rows, but I still have one non-summary task and a summary task not displaying a cost kpi graphical indicator. It's mind boggling.
Jul 12 2022 05:07 PM
@John-project Yes I tried a different field and made no difference. Not sure what you mean about trying XML. Maybe I’ll try Microsoft 365 support technician after all part of me paying an annual subscription is also for support.
Jul 12 2022 05:14 PM
Jul 13 2022 01:55 AM
Jul 13 2022 04:28 AM
@Ignacio_40 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.
Jul 13 2022 04:49 AM
@Ignacio_40 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.
Jul 13 2022 04:56 AMSolution
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.
Jul 13 2022 05:13 AM