Loading...
Quick Links

Formula in Ms Project

Home Forums Discussion Formula in Ms Project

  • This topic is empty.
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #410316 Reply
    Gamma Syahrial
    Guest

    Hello, iam currently using Ms Project 2016 stand alone, and iam trying to make schedule for construction project
    iam having troube making formula in Ms Project to find out progress percentage of some task (this progress is base on value of money)
    if iam using Excel the formula for this is “(Volume x base price) / Total Cost of the Project”
    in Ms Project Formula “Total Cost of the Project” i input manually
    is there a formula to input “Total Cost of the Project” automatic by using total sum of cost column?

    Thank You

    #484957 Reply
    Klais Surik
    Guest

    Even this activity area appears to be affected. I adore casinos, it’s unfortunately. Casinos. Casinos. Online play is a tremendous opportunity. That’s OK. That’s OK. The most important thing for me is the safety and bonus availability at a casino. Therefore, when I choose a platform, I pay attention to that initially. I chose my own, with https://pmwin1.com/ specifications. I decided. I received a bonus and a full return on registration, the first play and the first deposit. I was interested in these terms and offered them so I decided to test them.

    #484979 Reply
    Ismet Kocaman
    Guest

    There is no project level field (e.g., Project Start, Project Finish) that can be referenced in a custom field formula in order to get the total project cost.

    That was my five-vote suggestion on the UserVoice, see here: https://microsoftproject.uservoice.com/forums/910931-project-online/suggestions/32026375-project-work-and-project-cost-fields-in-the-future

    #485244 Reply
    miles goodchild
    Guest

    There is no way to do this in MS Project for a specific task, it would be possible to do a total across the project but that isn’t what you’re trying to do. The best way to do this would be to pull the required data out of the MS project using a view that displays the data that you need and then drop it into Excel to do the calculation. You could then copy and paste the data back into a custom text or number field to display as you want in Project. This custom field could be present in the custom view. There is a risk that the data presented is out of date if the plan changes between refreshes of the custom display field however the process would be quick:
    * display custom view “Cost Progress”
    * copy the columns needed in excel
    * Paste into Excel and then copy the output column
    * Paste back into MS project.
    HTH
    Miles

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Reply #484979 in Formula in Ms Project
Your information: