Un-doing Summarizing Sums on Cost Fields

[lgilbert]

Hi --
I've got a project with custom cost fields that
originally I elected to rollup by sum for the sub-tasks.
Now I have an application that needs to export these
columns and I need them not to rollup by sum anymore.
When I try to toggle from "Rollup" to "None" in the
column customize fields/properties box, it does nothing
and remains summed at the higher task.

Any ideas?

Thanks!
Leslie

 

[Gérard Ducouret]

Hello Leslie,
You are right, Ms Project has a strange behavior at this point. (I checked
it on both 2002 and 2003 versions)
Just a noticeable difference : when the Rollup feature is set, the summary
sum is "protected" by the formula : you can't edit nor erase it. When it is
not, you can edit or erase it.
You could do that with a small VBA procedure like the following (which
assumes that you are using the Cost1 field)

Hope this helps,

Gérard Ducouret [Project MVP]
Pragmasoft ® - Paris

Sub ClearSummary()
Dim oTask As Object
For Each oTask In ActiveProject.Tasks
If Not oTask Is Nothing Then
If oTask.Summary = True Then
oTask.Cost1 = 0
End If
End If
Next
End Sub