A
aSoundMind
Hi There,
I have a formula for enterprise task text8 which is
IIf([% Complete]<100,datediff("d",[Baseline
Finish],date()),DateDiff("d",[Baseline
Start],[Finish])-DateDiff("d",[Baseline Start],[Baseline Finish]))
The formula seems to be working fine. However there's a slight issue
here
where the task head also displays the graph indicator and they display
it
wrongly, Otherwise on task child level it is working just fine.
This is a sample scenario
wbs || task || % complete || base start || base finish || act
start
|| act finish
1. testa task 1 100 3/26/2007 3/26/2007
3/26/2007 3/26/2007
1.1. testa task 1a 100
2. testa task 2 50
2.2. testa task 2b 50
The basestart, basefinish, act start, act finish are all the same for
all
the WBS which is 3/26/2007. For wbs 1 and 1.1. the graph indicator is
green.
As for wbs 2. is green, and 2.2. is red.
The correct one shud be
1. green
1.1. green
2. red
2.1. red
When I mouse over 1.1 I can see the data displays 0, but nothing is
displayed on 1.
Same goes to 2. I can't see the data being displayed and it shows 46
for 2.1.
I hope my explanation is clear enough to describe it. Thanks in
advance.
Regards,
Jack
I have a formula for enterprise task text8 which is
IIf([% Complete]<100,datediff("d",[Baseline
Finish],date()),DateDiff("d",[Baseline
Start],[Finish])-DateDiff("d",[Baseline Start],[Baseline Finish]))
The formula seems to be working fine. However there's a slight issue
here
where the task head also displays the graph indicator and they display
it
wrongly, Otherwise on task child level it is working just fine.
This is a sample scenario
wbs || task || % complete || base start || base finish || act
start
|| act finish
1. testa task 1 100 3/26/2007 3/26/2007
3/26/2007 3/26/2007
1.1. testa task 1a 100
2. testa task 2 50
2.2. testa task 2b 50
The basestart, basefinish, act start, act finish are all the same for
all
the WBS which is 3/26/2007. For wbs 1 and 1.1. the graph indicator is
green.
As for wbs 2. is green, and 2.2. is red.
The correct one shud be
1. green
1.1. green
2. red
2.1. red
When I mouse over 1.1 I can see the data displays 0, but nothing is
displayed on 1.
Same goes to 2. I can't see the data being displayed and it shows 46
for 2.1.
I hope my explanation is clear enough to describe it. Thanks in
advance.
Regards,
Jack