Graphical Indicator displaying data instead of graphical indicator

S

Stacey

Hi,

I have a graphical indicator with the following formula and on my view, the
column is showing as data instead of the graphical indicator. I have
indicators set up for Complete, Not Baselined, etc. On the Enterprise Custom
Fields page, it even says there is a graphical indicator. Any ideas why it's
showing the words instead of the picture?

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"))))

Thank you! Thank you!
Stacey
 
D

Dale Howard [MVP]

Stacey --

Where in PWA are you attempting to display this field with Graphical
Indicators? It would help if we knew that before we can troubleshoot your
problem. Let us know.
 
M

Marc Soester [MVP]

Hi Stacey,

I would check the obious. can you make sure that your graphical indicators
are setpu so that the words you have in your formula match, including spaces
etc. exactly to what you have in your graphical indictar screen when you set
up the formulas. I see often that the word is not spelled correctly and
therefore it displays the word.

Hope this helps and let me know how you go
 
S

Sean Hanson

We found we had to publish the schedules to get the graphical display to show
instead of the text. Try a few projects and let me know.
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting
SRS Report Packs


Marc Soester said:
Hi Stacey,

I would check the obious. can you make sure that your graphical indicators
are setpu so that the words you have in your formula match, including spaces
etc. exactly to what you have in your graphical indictar screen when you set
up the formulas. I see often that the word is not spelled correctly and
therefore it displays the word.

Hope this helps and let me know how you go

--
Marc Soester [MVP]
http://marcsoester.blogspot.com


Stacey said:
Hi,

I have a graphical indicator with the following formula and on my view, the
column is showing as data instead of the graphical indicator. I have
indicators set up for Complete, Not Baselined, etc. On the Enterprise Custom
Fields page, it even says there is a graphical indicator. Any ideas why it's
showing the words instead of the picture?

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"))))

Thank you! Thank you!
Stacey
 
S

Stacey

Hi Dale,

I am looking at it from Project itself (not PWA). I am using a view I made
with my new custom field.

Thoughts?

Dale Howard said:
Stacey --

Where in PWA are you attempting to display this field with Graphical
Indicators? It would help if we knew that before we can troubleshoot your
problem. Let us know.




Stacey said:
Hi,

I have a graphical indicator with the following formula and on my view,
the
column is showing as data instead of the graphical indicator. I have
indicators set up for Complete, Not Baselined, etc. On the Enterprise
Custom
Fields page, it even says there is a graphical indicator. Any ideas why
it's
showing the words instead of the picture?

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"))))

Thank you! Thank you!
Stacey
 
S

Stacey

Hi Marc,

I checked the words (including spaces). They shouldn't be in quotes in the
"Values to Display" section...right?

Thanks!

Marc Soester said:
Hi Stacey,

I would check the obious. can you make sure that your graphical indicators
are setpu so that the words you have in your formula match, including spaces
etc. exactly to what you have in your graphical indictar screen when you set
up the formulas. I see often that the word is not spelled correctly and
therefore it displays the word.

Hope this helps and let me know how you go

--
Marc Soester [MVP]
http://marcsoester.blogspot.com


Stacey said:
Hi,

I have a graphical indicator with the following formula and on my view, the
column is showing as data instead of the graphical indicator. I have
indicators set up for Complete, Not Baselined, etc. On the Enterprise Custom
Fields page, it even says there is a graphical indicator. Any ideas why it's
showing the words instead of the picture?

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"))))

Thank you! Thank you!
Stacey
 
S

Stacey

Hi Sean,

I tried publishing and it still shows as data instead of graphical.

Thoughts?

Sean Hanson said:
We found we had to publish the schedules to get the graphical display to show
instead of the text. Try a few projects and let me know.
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting
SRS Report Packs


Marc Soester said:
Hi Stacey,

I would check the obious. can you make sure that your graphical indicators
are setpu so that the words you have in your formula match, including spaces
etc. exactly to what you have in your graphical indictar screen when you set
up the formulas. I see often that the word is not spelled correctly and
therefore it displays the word.

Hope this helps and let me know how you go

--
Marc Soester [MVP]
http://marcsoester.blogspot.com


Stacey said:
Hi,

I have a graphical indicator with the following formula and on my view, the
column is showing as data instead of the graphical indicator. I have
indicators set up for Complete, Not Baselined, etc. On the Enterprise Custom
Fields page, it even says there is a graphical indicator. Any ideas why it's
showing the words instead of the picture?

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"))))

Thank you! Thank you!
Stacey
 
D

Dale Howard [MVP]

Stacey --

OK. What are your criteria for the Graphical Indicators? Let us know and
we will try to help.




Stacey said:
Hi Dale,

I am looking at it from Project itself (not PWA). I am using a view I made
with my new custom field.

Thoughts?

Dale Howard said:
Stacey --

Where in PWA are you attempting to display this field with Graphical
Indicators? It would help if we knew that before we can troubleshoot
your
problem. Let us know.




Stacey said:
Hi,

I have a graphical indicator with the following formula and on my view,
the
column is showing as data instead of the graphical indicator. I have
indicators set up for Complete, Not Baselined, etc. On the Enterprise
Custom
Fields page, it even says there is a graphical indicator. Any ideas
why
it's
showing the words instead of the picture?

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"))))

Thank you! Thank you!
Stacey
 
M

Marc Soester [MVP]

Hi Stacey,

thats right, they should not be in quotes.
--
Marc Soester [MVP]
http://marcsoester.blogspot.com


Stacey said:
Hi Marc,

I checked the words (including spaces). They shouldn't be in quotes in the
"Values to Display" section...right?

Thanks!

Marc Soester said:
Hi Stacey,

I would check the obious. can you make sure that your graphical indicators
are setpu so that the words you have in your formula match, including spaces
etc. exactly to what you have in your graphical indictar screen when you set
up the formulas. I see often that the word is not spelled correctly and
therefore it displays the word.

Hope this helps and let me know how you go

--
Marc Soester [MVP]
http://marcsoester.blogspot.com


Stacey said:
Hi,

I have a graphical indicator with the following formula and on my view, the
column is showing as data instead of the graphical indicator. I have
indicators set up for Complete, Not Baselined, etc. On the Enterprise Custom
Fields page, it even says there is a graphical indicator. Any ideas why it's
showing the words instead of the picture?

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"))))

Thank you! Thank you!
Stacey
 
S

Stacey

Hi Dale,

The formula is the one you wrote answering another question of mine which is
also included in the original part of this discussion. The criteria for the
graphical indicators are:
equals Complete [checkmark indicator]
equals Not Baselined [white circle indicator]
etc.

Does this help?

Thank you!
Stacey

Dale Howard said:
Stacey --

OK. What are your criteria for the Graphical Indicators? Let us know and
we will try to help.




Stacey said:
Hi Dale,

I am looking at it from Project itself (not PWA). I am using a view I made
with my new custom field.

Thoughts?

Dale Howard said:
Stacey --

Where in PWA are you attempting to display this field with Graphical
Indicators? It would help if we knew that before we can troubleshoot
your
problem. Let us know.




Hi,

I have a graphical indicator with the following formula and on my view,
the
column is showing as data instead of the graphical indicator. I have
indicators set up for Complete, Not Baselined, etc. On the Enterprise
Custom
Fields page, it even says there is a graphical indicator. Any ideas
why
it's
showing the words instead of the picture?

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"))))

Thank you! Thank you!
Stacey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top