![]() |
|
|
|
#1
|
|||
|
|||
|
I want to show cum scheduled work to the status date for each task in a table column to help my cost control person understand the BCWS values that MSP calculates. I understand that this is displayed in the timescaled task usage field. Therefore it must be calculated internally by summing the timescaled scheduled work to the status date, but it is not offered as a custom field in MSP 2003. It appears that it is in later versions, and I am wondering if there is a formula I could use to customize a field to display in a column.
|
|
#2
|
|||
|
|||
|
Sorry, none of the fields in the table are timescaled data, they are summary data. Later versions do not offer any cumulative fields in any table view, only in timescaled views such as Task or Resource Usage.I suggest showing the BCWS data to the cost control person in the timescaled view along with the other timescaled values.
There is not, to the best of my knowledge a method of calculating that data through a custom field in a timescaled view. It may be possible through VBA, but I am not the person to aid you there, sorry. If you know VBA, you may try posting to the Microsoft Forum for Programming: https://social.technet.microsoft.com...ct2010custprog If you choose to post there, please explicitly state that you are using 2003 as things changed after that release. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Project 2013 - entering work hours at a monthly level | aj18 | Project | 4 | 05-26-2014 10:32 AM |
Excel 2010- What does this formula mean and how does it work
|
dangoodwin1 | Excel | 1 | 10-31-2012 09:18 PM |
| formula to work from data column | masterdineen | Excel | 16 | 08-09-2012 07:52 AM |
| How to show Vacations at the Bottom of Work Schedule in Office Project 2007? | Rahmat_uk20 | Project | 3 | 06-08-2012 01:53 PM |
Implementing excel formula in project
|
nawab35 | Project | 6 | 08-04-2011 05:45 AM |