Graphical Indicators Not Valid Error

[Stacey]

Hi!

I entered a custom field "Schedule Indicator" with the following formula,
which saved fine. When I go back to add graphical indicators (equals
Complete and picked Green circle) then it gives me this error "The graphical
indicators for the non-summary rows are not valid".

Formula:
Switch([Duration]>-1,IIf([% Complete]=100,"Complete",IIf([Baseline
Finish]=4294967295, "Not Baselined", IIf (([Finish]-[Baseline Finish]) >7,">1
Week Late", IIf (([Finish]-[Baseline Finish]) <=7 And ([Finish]-[Baseline
Finish])>0, "0 to 1 Week Late", "On Schedule")))), [Duration]<>0,"N/A")

Thank you for your help! Have a great day!

 

[Dale Howard [MVP]]

Stacey --

I believe your original formula is flawed. Your mix of the Switch and IIf
functions isn't working. Try the following formula instead:

IIf([% Complete]=100,"Complete",IIf([Baseline
Finish]=ProjDateValue("NA"),"Not Baselined",IIf(([Finish Variance]/[Minutes
Per Day])>5,">1 Week Late",IIf(([Finish Variance]/[Minutes Per Day])<=5 And
([Finish Variance])>0,"0 to 1 Week Late","On Schedule"))))

Please note in the above formula that I have done the following:

1. Stripped out the Switch function entirely.
2. Replace your test to determine if a Baseline has been saved with a
better test.
3. Replaced your [Finish]-[Baseline Finish] formula with the [Finish
Variance] field.
4. Divided the [Finish Variance] value by the [Minutes Per Day] value since
Finish Variance is stored in Minutes in Microsoft Project and needs to be
converted to Days.
5. Changed the criteria for "late" tasks from 7 days to 5 days since 5 days
constitutes one work week.

Please try testing the above formula in a custom Text field in a real
project. I believe you will find it works in all cases. Assuming so, set
your Graphical Indicator criteria and that should work as well. Hope this
helps.

Hi!

I entered a custom field "Schedule Indicator" with the following formula,
which saved fine. When I go back to add graphical indicators (equals
Complete and picked Green circle) then it gives me this error "The
graphical
indicators for the non-summary rows are not valid".

Formula:
Switch([Duration]>-1,IIf([% Complete]=100,"Complete",IIf([Baseline
Finish]=4294967295, "Not Baselined", IIf (([Finish]-[Baseline Finish])

7,">1

Week Late", IIf (([Finish]-[Baseline Finish]) <=7 And ([Finish]-[Baseline
Finish])>0, "0 to 1 Week Late", "On Schedule")))), [Duration]<>0,"N/A")

Thank you for your help! Have a great day!

 

[Stacey]

Thanks Dale, I like the changes you made, but now I get a syntax error (The
formula contains a syntax error or contains a reference to an unrecognized
field or function name)...thoughts?

 

[Dale Howard [MVP]]

Stacey --

Paste the formula into a Notepad document and then step out the forced
carriage returns between the lines. I had the same problem when I pasted
your formula directly from the newgroup. Hope this helps.

 

[Stacey]

You Rock! Thanks Dale!

Stacey --

Paste the formula into a Notepad document and then step out the forced
carriage returns between the lines. I had the same problem when I pasted
your formula directly from the newgroup. Hope this helps.

 

[Dale Howard [MVP]]

Stacey --

Are you saying I'm a rock star?