Microsoft KB Archive/117423

{|
 * width="100%"|

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

 * 1) From the View menu, choose Table, and then choose Cost.
 * 2) In the Cost Table, insert a Cost1 field. Choose OK, and then choose Close.
 * 3) Create two new tasks.
 * 4) Enter a cost amount in the Fixed Cost, Cost, and Cost1 fields for each of the two tasks.
 * 5) From the View menu, choose Reports.
 * 6) Double-click the Cost Reports option.
 * 7) 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:

Keywords :

Issue type : kbbug

Technology : kbHWMAC kbOSMAC kbProjectSearch kbProject400Mac kbProjectMacSearch kbProject400