expression in SSRS to rollup %complete RRS feed

  • Question

  • Hi every one

    I need to have a report like this :

    for "Total" row I need to have "%progress" for Program A based on a weight(cost).it's easy to do this in Excel (with SumProduct function) but I don't know How can I do this with expression. I think first of all I have to have total cost as a variable then Cost/total cost. by doing this I can have for every project its weight based on its costafter that i need a expression like sumproduct in excel to calculate %progress for Total.

    let me know how I can have this kind of reports

    Tuesday, May 7, 2013 11:45 AM

All replies

  • Sam-Net,

    I am not sure if this is really a "MS Project" related question.

    Also, we do not have enough details to help you out. How are your individual % being calcuated. I cannot figure out the relationship between Weight(cost) and % progress in your diagram.

    More details would help.

    Prasanna Adavi, PMP, MCTS

    Wednesday, May 8, 2013 3:03 AM
  • Dear Prasanna,

    all %progress come from EPM and I need to have %progress for my Program which include several projects. I need to rollup its progress based on project's weight. all project's weight must be calculated based on project's cost

    in excel it's easy but for report in SSRS I have no idea how to do this

    Wednesday, May 8, 2013 7:31 AM