Add/ Edit Budget Template Line Item Formulas

You are able to create and add formulas per budget line item into the details of your budget template. Formulas might include numbers from other line items or project custom fields into the equation. For example, if you wanted to calculate your construction cost to be the estimated square footage multiplied by the cost per square foot, you could add two project custom fields in the equation to automatically calculate that number for you. Or, you might want to calculate the design fees to be a percentage of the total construction cost; in this case you could build a formula in which you pull in the construction line item and multiply that by a percentage.

The following instructions are provided below:

Add Budget Template Line Item Formulas

To add a formula for a budget line item in your budget template

  1. Go to the Budget Templates page.

    2. For more information see Access Budget Templates Page.

  2. Click the name of the template you want to add formulas to.

    3. The Edit Budget Template page is displayed.

  3. Click New.

    4. The Template Line Item Formula dialog box displays.

    Template Line Item Formula
  4. Click the Line Item or Custom Fields drop-down arrow to make a selection, and then click Insert to add this item to the Line Item Formula box.
  5. In the Operators section, select an applicable operator.

    6. This selection displays in the Line Item Formula box.

  6. Click the Line Item or Custom Fields drop-down arrow to make a selection, and then click Insert to add this item to the Line Item Formula box.
  7. After all elements of the formula have been configured, click Save.

Edit Budget Template Line Item Formulas

To edit a formula for a budget line item in your budget template

  1. Go to the Budget Templates page.

    2. For more information see Access Budget Templates Page.

  2. Click the Edit link located left of the template name.

    3. The Edit Budget Template page is displayed.

  3. In the Budget Template Line Items section, click the Edit link in the Formula section.

    4. The Template Line Item Formula dialog box displays for you to make changes to the formula.

  4. Click Save after all modifications are made.

If the budget template includes Budget Segment Overrides, the configurable field will be disabled. For more information on the budget segment override setting, see Add Budget Template Page Overview.