Finish Variance and % Complete Graphical Indicators RRS feed

  • Question

  • Hello, is there is way to have a blue mark display if % Complete of a project is 100 and keep the same parameters for Finish Variance?

    Thursday, April 5, 2018 9:04 PM

All replies

  • Hi,

    If I understand well, you want this indicator to show blue if %complete = 100%, otherwise show the color in your capture?

    In this case, you could use this formula:

    iif([%complete]=100;99999;[Finish Variance])

    Then use the same graphical indicator configuration and just add a condition: is equal to 99999 with a blue circle.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller

    Friday, April 6, 2018 8:51 AM
  • Hello Guillaume, thank you for your help. However, it seems as though the formula has an error in it? I am not very good at formulas, can you identify what is wrong?

    • Edited by triniman27 Tuesday, April 10, 2018 3:35 PM
    Friday, April 6, 2018 4:20 PM