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.
- Setting up portfolio measures
- Creating custom fields to calculate selection criteria
- Defining custom fields for risk measures
- Setting up resource planning
- Building a list of projects
- Adding graphical indicators to the portfolio dashboard
- Evaluating projects for the portfolio
- Reviewing demand and availability for each skill set
- Building a rough schedule
- Managing the portfolio