where is the cumulative baseline cost field RRS feed

  • Question

  • Anyone know where I can find the Cumulative Baseline Cost field ?

    Or a formula to calculate this in a Custom Field if it is not a standard field ?

    Many thanks

    Mick, Bristol, England

    Mick Delany

    Thursday, November 8, 2012 4:39 PM

All replies

  • Should have mentioned that I would like to see Cumulative Baseline Costs on the Visual Reports - Baseline Cost Report.

    Cumulative Cost is available but not Cumulative Baseline Cost.

    Many thanks,

    Mick, Bristol, England

    Mick Delany

    Thursday, November 8, 2012 4:45 PM
  • Mick --
    There is no Cumulative Baseline Cost field in any version of Microsoft Project, including the new 2013 version.  There are a number of new cumulative fields in Microsoft Project 2013, such as the Baseline Cumulative Work field, but there is no Baseline Cumulative Cost field.  So, there is no way to add the information you seek to any Visual Report.  Sorry.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    "We write the books on Project Server"

    Thursday, November 8, 2012 5:12 PM
  • You don't have to rely on visual reports to get what you want, which is basically a graph of cumulative baseline cost on a vertical axis and time on a horizontal axis.

    In the task usage view you can see the baseline cost for each day on the grid. You need to show the field and set the resolution and then copy the numbers and paste them into excel, make a little formula to accumulate them (like a running balance) and graph it in excel.

    I find I can make a nicer graph than the visual reports anyway, and the visual reports are tricky and fiddly to get what you want. The pivot tables drive me nuts. visual reports were just about the only new thing that was added to MSP in 2007, and I always thought that the way it was done in 2003 was good enough. and easy.

    Thursday, November 8, 2012 10:18 PM
  • I'm with Trevor on that one.  I typically just use the Export Wizard (Save As > Excel) to push the data into Excel and do the reporting there.....although with Project Server, it's actually easier to just create the reports with some SQL queries.

    Andrew Lavinsky [MVP] Blog: Twitter: @alavinsky

    Sunday, November 18, 2012 2:40 AM