Project: Cost1 Field Does Not Show Totals in Reports |
Q117423
The information in this article applies to:
-
Microsoft Project for Windows, version 4.0
-
Microsoft Project for the Macintosh, version 4.0
SYMPTOMS
In Microsoft Project, when you use the Reports command to create a report
such as a (budget or a task list ) that contains the Cost1, Cost2, or Cost3
field, and the report is printed or previewed with totals showing at the
bottom of each of the columns, then the totals are not displayed for the
Cost1, Cost2, or Cost3 columns.
WORKAROUND
To avoid this problem, use any of the workarounds below.
Use a field other than Cost1 to enter costs
For example, instead of entering costs in the Cost 1 field, enter them in
the Fixed Cost column. Fixed Cost is a good substitute for Cost 1 because the costs in this field are independent of the work of a resource, and a total for this column is shown in reports. Fixed Cost will also be added to the Total Cost of the Task.
If Fixed Cost is already in use, use a number field to keep track of costs
If the Fixed Cost field is already being used, then you can use a number
field, such as Number1, to keep track of costs. Totals of number fields
will be shown in Cost reports. This workaround has the drawback that the
currency sign ($ in the U.S. version) is not displayed.
Save the table in the Microsoft Excel file format
You can save the table containing the Cost1, Cost2, and/or Cost3 field can
be saved in the Microsoft Excel (.XLS) format. You can open this file in
Microsoft Excel and calculate totals for all of the columns in the
worksheet.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products that are listed
at the beginning of this article.
MORE INFORMATION
Microsoft Project is capable of generating totals in some reports for most
fields that exclusively use numbers. Microsoft Project 4.0 provides three
cost fields, Cost1, Cost2, and Cost3, that can be used to display costs
that are not included in the Fixed Cost or Total Cost fields.
Steps to Reproduce Behavior
- From the View menu, choose Table, and then choose
Cost.
- In the Cost Table, insert a Cost1 field. Choose
OK, and then choose Close.
- Create two new tasks.
- Enter a cost amount in the Fixed Cost, Cost, and
Cost1 fields for each of the two tasks.
- From the View menu, choose Reports.
- Double-click the Cost Reports option.
- Select the Budget report, and choose the Select
button.
In the above example, the print preview shows that all of the cost columns
contain totals except the Cost1 field. The same behavior is exhibited for
the Cost2 and Cost3 fields.
Additional query words: