Julie
Created and indicator for more, but still showing blank field where
indicator should be and error where text should be.
Carpy
:
Hi Daren
to test the formula you need to change the FINISH date not the
baseline
finish date
also you've not defined a graphical indicator for "more" so you'll
need
to
do that if you want it
btw if you complete all the tasks in your test.mpp to 100% you'll see
it
work.
Cheers
JulieD
Hi Daren
replied to your email - checking that
a) you have saved a baseline
b) you saved the baseline into the baseline field (not baseline1
etc)
apart from this i'm out of ideas ...
Cheers
JulieD
Hi Julie
I have sent you an email, but this seems to be quicker at getting
across
the
world. I have had a look at yours and where you have Number of
months
in
a
column, I have #ERROR and still no indicators.
Help!
Carpy (Aka Daren)
:
Hi Carpy
if you'ld like to email me direct, i'll send you a file where i've
got
it
set up and you can compare it to yours - alternatively if your
file
isn't
confidential email it to me and i'll take a quick look.
email address is julied_ng at hcts dot net dot au
Cheers
JulieD
Julie
Done that, set a task to 100% and moved the finish to date to
more
than 30
days from the baseline finish, but no indicator has appeared in
the
text
column I have created.
Carpy
:
Hi
no problem
when you're setting up the graphical indicators choose
"equals" in the first column and then in the second column you
need
to
type
the EXACT text that you have in the formula - from my last
formula
the
first
line would be
equals...................month................choose indicator
second line
equals...................two months.............choose
indicator
third line
equals..................more...................choose indicator
How did you go?
Cheers
JulieD
Julie
This is it, but I cannot seem to get the Graphical Indicators
to
correspond.
Last request, I promise.
Carpy
:
Hi Carpy
is this more along the lines of what you're after
IIf([% Complete]="100",IIf([Finish]-[Baseline
Finish]=0,"",IIf([Finish]-[Baseline
Finish]<=30,"month",IIf([Finish]-[Baseline Finish]<=60,"two
months","more"))),"")
Cheers
JulieD
Julie
I am only talking about 100% complete tasks. How can I
set
the
variance
to
show, for instance all those tasks which vary between 1
and
30
under
one
indicator.
Carpy
:
Hi Carpy
sorry another thought ... if you're talking about 100%
complete
tasks
as
well as tasks in progress change the formula to
IIf([Finish]-[Baseline Finish]>7,"over
week",IIf([Finish]-[Baseline
Finish]<=0,"on target","week"))
still changing the 7 to the number of days you want to
indicate
the
variance
for
Cheers
JulieD
message
Julie
Thanks for this, something not working quite right
though.
What
does
the 7
relate in this forumula. IIf([%
Complete]<>"100",IIf([Finish]-[Baseline
Finish]>7,"over
week",IIf([Finish]-[Baseline Finish]<=0,"on
target","week")),"NA")
If this is as it should be then I am not putting
correct
info
into
Graphical
Indicators.
Help!
Carpy
:
Hi Carpy
here's a link to an earlier discussion on this topic
http://tinyurl.com/4b3ho
here's also another article on how to implement this -
using
cost
fields
as
an example
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=403
if you need more information please us know.
Cheers
JulieD
message
Hi there,
I wonder if someone can tell me how to do the
following:
I am trying to customise a field to show all those
tasks
where
they
have
finished past the scheduled Baseline date. Also
need
to
show
this
at
the
various intervals with different colours. eg, Less
than
a
month
past,
1-2
months etc.
Any help greatly appreciated.
Carpy
