Karen said:Total Costs shows zero yet the formula for graphical indicators was cost >
10K "Low". Everything turned up red. Can anyone explain this to me?
John said:Karen,
Say what? "cost > 10K "Low" is not a formula. Neither is it a criteria
for a graphical indicators. How about you explain it a little better.
Then maybe we can help.
John
Project MVP
Karen said:IIf([Cost]>10000,[Cost],"Low")
John said:Karen said:IIf([Cost]>10000,[Cost],"Low")
Karen,
Well at least that's a formula but it doesn't give enough information
for us to be able to help you. What field are you trying to customize?
How did you set up your graphical indicator criteria?
You want an explanation but in order for us to provide that you need to
give us an explanation of what you have first.
John
Project MVP
Karen said:I'm into the no clue phase here so here it goes: Field I am trying to
cutomize is Text2 (relating to Cost) for the graphical indicators. The
graphical indicators limits are >10000, >=5000, and <5000. I don't know if
this answers your questions or not.
<5000 Green10,000 Red
=5000 Yellow
John said:Karen said:IIf([Cost]>10000,[Cost],"Low")
Karen,
Well at least that's a formula but it doesn't give enough information
for us to be able to help you. What field are you trying to customize?
How did you set up your graphical indicator criteria?
You want an explanation but in order for us to provide that you need to
give us an explanation of what you have first.
John
Project MVP:
Total Costs shows zero yet the formula for graphical indicators was
cost
10K "Low". Everything turned up red. Can anyone explain this to me?
Karen,
Say what? "cost > 10K "Low" is not a formula. Neither is it a criteria
for a graphical indicators. How about you explain it a little better.
Then maybe we can help.
John
Project MVP
John said:Karen said:I'm into the no clue phase here so here it goes: Field I am trying to
cutomize is Text2 (relating to Cost) for the graphical indicators. The
graphical indicators limits are >10000, >=5000, and <5000. I don't know if
this answers your questions or not.
Karen,
Still a little sparse on the info, but you're getting there. I've got
your formula, I've got the field you customized, and I've got the
graphical indicators limits. What I don't have is what indicators (e.g.
color) you have attached to the criteria, but I can probably wing it on
that.
I'll arbitrarily make the assumption that you set the graphical
indicators as follows,<5000 Green10,000 Red
=5000 Yellow
The basic crux of the problem is that the formula you developed either
puts out a numerical value (i.e. the Cost field) which will always be a
values greater than 10,000, or a text value (i.e. "low"). If the
graphical indicators are set up as I assumed above, then all values will
show a red stop light because any cost values greater than 10,000 will
of course be red, but also, any text value will show as red because text
values equate to very large numerical values when compared to a
numerical criteria. In effect, all "low" results will be extremely
large, from a numerical standpoint, and so they will be red also.
But, rather than have me go on and on about what you might or might not
have, why don't you explain your end goal. That is, what do you want?
Then I can get to specifics and come up with a workable solution.
John
Project MVPJohn said:IIf([Cost]>10000,[Cost],"Low")
Karen,
Well at least that's a formula but it doesn't give enough information
for us to be able to help you. What field are you trying to customize?
How did you set up your graphical indicator criteria?
You want an explanation but in order for us to provide that you need to
give us an explanation of what you have first.
John
Project MVP
:
Total Costs shows zero yet the formula for graphical indicators was
cost
10K "Low". Everything turned up red. Can anyone explain this to me?
Karen,
Say what? "cost > 10K "Low" is not a formula. Neither is it a criteria
for a graphical indicators. How about you explain it a little better.
Then maybe we can help.
John
Project MVP
Karen said:I'm looking for cost overruns in a trial project I'm experimenting with so I
can learn about using graphical indicators/formulas (following example from
Microsoft Project 14 - Customizing fields [Mike Glen]). Your assumptions on
the light colors were correct. Can graphical indicators also be used to track
whether or not projects are on time?
John said:Karen said:I'm into the no clue phase here so here it goes: Field I am trying to
cutomize is Text2 (relating to Cost) for the graphical indicators. The
graphical indicators limits are >10000, >=5000, and <5000. I don't know
if
this answers your questions or not.
Karen,
Still a little sparse on the info, but you're getting there. I've got
your formula, I've got the field you customized, and I've got the
graphical indicators limits. What I don't have is what indicators (e.g.
color) you have attached to the criteria, but I can probably wing it on
that.
I'll arbitrarily make the assumption that you set the graphical
indicators as follows,<5000 Green10,000 Red
=5000 Yellow
The basic crux of the problem is that the formula you developed either
puts out a numerical value (i.e. the Cost field) which will always be a
values greater than 10,000, or a text value (i.e. "low"). If the
graphical indicators are set up as I assumed above, then all values will
show a red stop light because any cost values greater than 10,000 will
of course be red, but also, any text value will show as red because text
values equate to very large numerical values when compared to a
numerical criteria. In effect, all "low" results will be extremely
large, from a numerical standpoint, and so they will be red also.
But, rather than have me go on and on about what you might or might not
have, why don't you explain your end goal. That is, what do you want?
Then I can get to specifics and come up with a workable solution.
John
Project MVP:
IIf([Cost]>10000,[Cost],"Low")
Karen,
Well at least that's a formula but it doesn't give enough information
for us to be able to help you. What field are you trying to customize?
How did you set up your graphical indicator criteria?
You want an explanation but in order for us to provide that you need to
give us an explanation of what you have first.
John
Project MVP
:
Total Costs shows zero yet the formula for graphical indicators
was
cost
10K "Low". Everything turned up red. Can anyone explain this to
me?
Karen,
Say what? "cost > 10K "Low" is not a formula. Neither is it a
criteria
for a graphical indicators. How about you explain it a little
better.
Then maybe we can help.
John
Project MVP
John said:Karen said:I'm looking for cost overruns in a trial project I'm experimenting with so I
can learn about using graphical indicators/formulas (following example from
Microsoft Project 14 - Customizing fields [Mike Glen]). Your assumptions on
the light colors were correct. Can graphical indicators also be used to track
whether or not projects are on time?
Karen,
OK, now we've got something to work with. First of all, you don't need a
formula in Text2. All you need to do is to replicate the Cost field in a
spare field that can be customized (e.g. Text2). The following will do
that. (Technically it is a "formula" but I don't really consider it as
such since it is not calculating anything.)
Text2 = [Cost]
Given that and the indicator criteria I showed in my previous response,
the Text2 field will now correctly show the indicators based on the
value in the Cost field.
Hopefully this clarifies things.
John
Project MVPJohn said:I'm into the no clue phase here so here it goes: Field I am trying to
cutomize is Text2 (relating to Cost) for the graphical indicators. The
graphical indicators limits are >10000, >=5000, and <5000. I don't know
if
this answers your questions or not.
Karen,
Still a little sparse on the info, but you're getting there. I've got
your formula, I've got the field you customized, and I've got the
graphical indicators limits. What I don't have is what indicators (e.g.
color) you have attached to the criteria, but I can probably wing it on
that.
I'll arbitrarily make the assumption that you set the graphical
indicators as follows,
10,000 Red
=5000 Yellow
<5000 Green
The basic crux of the problem is that the formula you developed either
puts out a numerical value (i.e. the Cost field) which will always be a
values greater than 10,000, or a text value (i.e. "low"). If the
graphical indicators are set up as I assumed above, then all values will
show a red stop light because any cost values greater than 10,000 will
of course be red, but also, any text value will show as red because text
values equate to very large numerical values when compared to a
numerical criteria. In effect, all "low" results will be extremely
large, from a numerical standpoint, and so they will be red also.
But, rather than have me go on and on about what you might or might not
have, why don't you explain your end goal. That is, what do you want?
Then I can get to specifics and come up with a workable solution.
John
Project MVP
:
IIf([Cost]>10000,[Cost],"Low")
Karen,
Well at least that's a formula but it doesn't give enough information
for us to be able to help you. What field are you trying to customize?
How did you set up your graphical indicator criteria?
You want an explanation but in order for us to provide that you need to
give us an explanation of what you have first.
John
Project MVP
:
Total Costs shows zero yet the formula for graphical indicators
was
cost
10K "Low". Everything turned up red. Can anyone explain this to
me?
Karen,
Say what? "cost > 10K "Low" is not a formula. Neither is it a
criteria
for a graphical indicators. How about you explain it a little
better.
Then maybe we can help.
John
Project MVP
Karen said:It worked! Thank you!
John said:Karen said:I'm looking for cost overruns in a trial project I'm experimenting with
so I
can learn about using graphical indicators/formulas (following example
from
Microsoft Project 14 - Customizing fields [Mike Glen]). Your assumptions
on
the light colors were correct. Can graphical indicators also be used to
track
whether or not projects are on time?
Karen,
OK, now we've got something to work with. First of all, you don't need a
formula in Text2. All you need to do is to replicate the Cost field in a
spare field that can be customized (e.g. Text2). The following will do
that. (Technically it is a "formula" but I don't really consider it as
such since it is not calculating anything.)
Text2 = [Cost]
Given that and the indicator criteria I showed in my previous response,
the Text2 field will now correctly show the indicators based on the
value in the Cost field.
Hopefully this clarifies things.
John
Project MVP:
I'm into the no clue phase here so here it goes: Field I am trying to
cutomize is Text2 (relating to Cost) for the graphical indicators.
The
graphical indicators limits are >10000, >=5000, and <5000. I don't
know
if
this answers your questions or not.
Karen,
Still a little sparse on the info, but you're getting there. I've got
your formula, I've got the field you customized, and I've got the
graphical indicators limits. What I don't have is what indicators (e.g.
color) you have attached to the criteria, but I can probably wing it on
that.
I'll arbitrarily make the assumption that you set the graphical
indicators as follows,
10,000 Red
=5000 Yellow
<5000 Green
The basic crux of the problem is that the formula you developed either
puts out a numerical value (i.e. the Cost field) which will always be a
values greater than 10,000, or a text value (i.e. "low"). If the
graphical indicators are set up as I assumed above, then all values
will
show a red stop light because any cost values greater than 10,000 will
of course be red, but also, any text value will show as red because
text
values equate to very large numerical values when compared to a
numerical criteria. In effect, all "low" results will be extremely
large, from a numerical standpoint, and so they will be red also.
But, rather than have me go on and on about what you might or might not
have, why don't you explain your end goal. That is, what do you want?
Then I can get to specifics and come up with a workable solution.
John
Project MVP
:
IIf([Cost]>10000,[Cost],"Low")
Karen,
Well at least that's a formula but it doesn't give enough
information
for us to be able to help you. What field are you trying to
customize?
How did you set up your graphical indicator criteria?
You want an explanation but in order for us to provide that you
need to
give us an explanation of what you have first.
John
Project MVP
:
Total Costs shows zero yet the formula for graphical
indicators
was
cost
10K "Low". Everything turned up red. Can anyone explain this
to
me?
Karen,
Say what? "cost > 10K "Low" is not a formula. Neither is it a
criteria
for a graphical indicators. How about you explain it a little
better.
Then maybe we can help.
John
Project MVP
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.