none
How to Rollup Summary Cost based on Criteria from Custom Field RRS feed

  • Question

  • Hello everybody,

    I am using MS-Project to create a RoadMap for my team. My challenge is to present show the total cost of each activity based on Period of Performances, like a table for example

    BY  10/1/2017 - 12/30/2018 Cost $####.####.00 

    OY1 12/31/2018 - 12/31/2019 Cost $####.####.00 

    OY2 12/31/2019 - 12/31/2020 Cost $####.####.00 

    OY3 12/31/2020 - 12/31/2021 Cost $####.####.00 

    I create a sample project in MS Project 2013.  I am providing a snapshot picture since I can't attach a file.   Create a Custom filed which provides the "headers" I need.  Next Step is how to show the sum in the Tasks and then on Gantt Chartt.  The Cost should go to Task 3, 4, 5, 6 

    I used the nested iff statement 

    IIf([Start]>=Cdate("10/1/2017") And [Start]<=CDate("12/30/2018"),"BY01",
    IIf([Start]>=Cdate("12/31/2018") And [Start]<=CDate("12/30/2019"),"OY1",
    IIf([Start]>=Cdate("12/31/2019") And [Start]<=CDate("12/30/2020"),"OY2",
    IIf([Start]>=Cdate("12/31/2020") And [Start]<=CDate("12/30/2021"),"OY3","N/A"))))

    Thursday, September 8, 2016 6:44 PM

All replies

  • ckandreou,

    Why did you cross post?

    The same questions I asked on the Answers forum still apply and the image you post here is still too small to be of any use.

    What exactly do you mean by "headers"?

    Where exactly are you trying to show the date range costs?

    Did you consider using the Task Usage or Resource Usage views instead?

    John

    Thursday, September 8, 2016 8:02 PM