Creating a formula to calculate field values

- There's no end to what you can do…with custom field formulas.…You can create tests with project fields,…arithmetic operators, logical functions,…and comparison values.…There are also dozens of other functions…you can use to include if then clauses,…convert values, or format dates and numbers.…Let's set up a formula for the Average Area per Day field…that we named in another movie.…I'm gonna start by choosing the tracking table in this view.…I head over to the Select All cell…at the top left of the table,…right click that cell,…and choose Tracking.…

I'm gonna save this as a new table…before I add my custom fields.…To do that I'm gonna head to the View tab,…click the Tables button,…and down at the bottom of the menu…choose Save Fields as a New Table.…I'm gonna call it Output and click okay.…Now that I've got my new table…I'm gonna insert those custom fields.…I'll right click the Actual Start heading,…choose Insert Column,…and the field that I want is the Area field.…I start to type the alias,…I see it right away in the drop down list,…