Cost Current, Cost Previous and Cost for Period

[Glenn]

Hi all,

Is there a way to pull Cost Current, Cost Previous and Cost for Period out
of Project at any point in time?

For example:
Cost Current could be the Actual Cost field at the current Status Date
Cost Previous could be at the cost at the last recording period
Cost for Period would be the Cost Current minus the Cost Previous

thanks,
glenn

 

[Dave]

Hi all,

Is there a way to pull Cost Current, Cost Previous and Cost for Period out
of Project at any point in time?

For example:
Cost Current could be the Actual Cost field at the current Status Date
Cost Previous could be at the cost at the last recording period
Cost for Period would be the Cost Current minus the Cost Previous

thanks,
glenn

The easiest way is probably to use one of the spare cost fields, Cost1
for example.

Then you can copy the actual cost column to this field when you do this
exercise (click on the header of the "Actual Cost" column to select the
entire column).

Then you can add the Cost2 column. If you customise this with the formula:

[Actual Cost] - [Cost1]

then you should have pretty much what you want.