none
Project Server 2010 Formula Field - Aggregated Cost Data from Schedule RRS feed

  • Question

  • Hello,

    I'd like to know if the following is possible...

    My MSP schedule looks like this..Column Headers are Task, Start Date, End Date & Task Cost.

    E.g. Two tasks

    Initialise Project  10/10/12  17/10/12  $10,000

    Develop Project Brief  17/10/12  23/10/12  $5,000

    ..What I'd like to do is create an Enterprise Custom Field (Project Entity) that aggregates all Task Costs entered against each Task within the Project Schedule, and that can be displayed in Project Center.

    Can this be done using the ECF formula functionality, if so, how?  I can't see a SUM function, or similar way to do this..

    Thanks in advance,

    Nick

    Wednesday, October 31, 2012 3:01 AM

All replies

  • Hi Nick,

    is Task Cost a custom field? In this case, define it to roll up to summary level as "Sum". Create a project level field as [Task Cost], and you should be fine.

    If it is default field "Cost", yo can just use Project field "Cost" in your Project Center view.

    Does that help?
    Barbara

    Wednesday, October 31, 2012 9:48 AM
    Moderator