Learn how to set up custom fields with formulas to calculate criteria values.
- [Instructor] Sometimes, selection criteria…require calculations. For example, if you want to use…a weighted average to decide which projects…do the best job at supporting organization goals.…That's where formulas and custom fields come in handy.…The first calculated field that we're going to set up…is one to show the project profit.…So I'm going to go to the Project tab,…and then click Custom Fields. It's going to be a number field.…
In the Type drop-down list, choose Number.…And we're going to use field Number10.…I'm going to click the Rename button…and we'll call this Project profit.…Go ahead and click OK. Now that it's…renamed, we're going to add the formula.…So beneath the list, click the Formula button.…That opens up the Formula dialogue box…and we're ready to add our formula.…So what is the Project profit?…Basically, it's the revenue minus the cost.…
But let's say that we want this as a percentage,…because that makes it easier to compare projects…of different sizes. To do that,…we're going to subtract the cost from the revenue,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Recall how to define custom fields to create a risk score for a project.
- Explain the advantages of using generic resources.
- Recognize the steps to take to determine resource availability for a project.
- Explain how to view a schedule based on project priority.
- Identify the importance of changing a project portfolio’s status from Active to Complete.
- Determine how to create a report that shows active and backlog projects.