In this video, see how to build a custom formula to display when your durations exceed your baseline estimate.
- [Narrator] Now that we understand some of the fields,…functions and operators within…the calculation dialogue box for custom formula,…we can go off and start to build our own.…Our team has asked us to build a custom duration field…to calculate the original duration to it's current duration…to see whether there's a variance.…We're going to go to the Custom Fields…on the Project ribbon.…We'll switch to the Task side,…since that's where they'd like to see it…on a per task basis.…And of course, we'll select the type Duration.…
We'll rename our Duration1 field to Duration Indicator…and we'll press OK.…Now we'll build out our formula to go with it.…So, we'll press the Formula button…and we'll use a field that comes out of the box,…so we'll go down to the insert options and select Duration…and next, Duration Variance.…Now we're setting a current custom field…equal to one that comes out of the box.…You might say…"Why are we doing this, because it's rather simple?"…Well, since the current duration variance field…that's in project, I can't edit it to do additional things,…
Note: This course was designed in collaboration with Bonnie Biafore.
- Name the default field radio button in custom fields.
- Explain what it means when a field is a dimension, when you are creating custom fields.
- List the steps to roll values to a top level of a project based on a properly setup a duration indicator.
- Identify the two parts needed to build an IF formula.
- Explain how a switch statement works.
- Assess why it is important to carefully choose graphical indicators.