Andrew:
I suspect that the summary tasks that behave badly weren't always summary
tasks, meaning that they contain residual data from a time when they were
non-summary tasks. You can see for yourself if this is the case simply by
out-denting the tasks below the summary and look at the values that surface.
If you see duration values, work values and such when you do this, then you
have your answer.
Keep in mind that turning a task into a summary task changes its behavior,
but not any underlying data that has already been added to it before it got
"repurposed."
Andrew K said:
John, The problem isn't that I have summary lines with future Finish dates
(!), it's that my customized field returns values for them. The formula
IIf(datediff("d",[Finish],NOW())>0,datediff("d",[Finish],NOW()),"")
shouldn't
return a number at all if the Finish date is later than NOW(). Works fine
with detail tasks but erratic with summary lines.
John said:
John,
Thanks for replying. Show Summary rows is checked because we need to
see
the structure.
I've noticed that the field shows incorrect values (i.e., days late for
future finish dates) for summary rows after some scheduled dates are
changed
several times. I can reproduce the problem by creating date
constraints
(like our beloved users do). It looks like the field returns values
it
calculates before I make changes. What do you think? I chose to use a
Text
field because I can't suppress 0's in a Number field.
Andrew,
What do I think? I think I'm confused. Your original post said you had
some summary lines showing even though the finish date was later than
today's date. I asked if you had the filter option to show related
summary rows and you said you did. Therefore you should expect to see
some summary rows with finish dates later than today's date. What am I
missing?
I need more clarification before I can agree that you have a problem
and/or suggest a possible solution. Also, I assume you have calculation
set to automatic as Julie suggested.
John
Project MVP
:
A text field with
IIf(datediff("d",[Finish],NOW())>0,datediff("d",[Finish],NOW()),"")
returns
Days Late. I've set Use Formula for summary rows, and a filter
shows
only
incomplete tasks. The results are erratic -- some summary rows
with
Finish
dates in the future display Days Late values. What am I missing?
Andrew,
My first guess is about your filter setting. Do you have the option
to
"Show related summary rows" checked or unchecked?
John
Project MVP
