none
Project Server cost calculation RRS feed

  • Question

  • Hi All,

    We are using project server 2013. I have two fields 'vendor cost' and 'payment status' at task level. I need to sum all the vendor cost where the payment status is paid and display in a custom field at project level. How to achieve this.


    Thanks in advance, Taj


    • Edited by arun_2014 Sunday, May 11, 2014 8:05 AM
    Sunday, May 11, 2014 8:05 AM

Answers

  • Hi,

    you need two additional fields, one on task level and one on project level:

    • "IIf([Payment Status] = "paid", [Vendor Cost], 0)" as formula on task level with type "Cost", with setting "Rollup - Sum" for "Calculation for Summary Rows ". I called it "Paid Vendor Cost Task".
    • A cost field ("Paid Vendor Cost" in my sample) on project level with formula [Paid Vendor Cost Task].

    It will give you the result.

    Does that work?
    Regards
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    • Marked as answer by arun_2014 Monday, May 12, 2014 12:28 PM
    Sunday, May 11, 2014 9:27 AM
    Moderator