Use this procedure to include a formula column in schedules created from a schedule table style. Property definitions in the formula dialog box are limited to the objects or styles to which the schedule table applies.
Use the formula column to create an expression based on the quantity or any other property set definition included in the schedule table style. For example, you can use a formula column to multiply a unit cost for an object by the number of objects to get a total cost.
- Click
. 
The Style Manager is displayed with the current drawing expanded in the tree view.
- Expand Documentation Objects, and expand Schedule Table Styles.
- Select the schedule table style that you want to change.
- Click the Columns tab, and click Include Quantity Column if you want to insert quantities in your formula column.
- Click Add Formula Column.
- On the Add Formula Column worksheet, specify properties for the formula:
If you want to… Then… identify the formula column with a heading enter text for Heading. specify a data format for the formula result select a data format. change the format and orientation for cells in the column click Override Cell Format, and specify format settings that apply only to data cells in this column. change the format and orientation for the column heading click Override Header Format, and specify format settings that apply only to data cells in this column. report a total value from all the values in this column select Total. hide the column from view in the drawing select Hide. create a formula that calculates a total using property data from all columns click Apply Formula to Total. Note: Hiding a column does not change the data displayed in it or any other column in the table. It only affects the display of the data. - Enter the formula:
If you want to… Then… use a value that you supply click in the Formula pane, and enter the value. use the value of another property definition in the formula locate and double-click (or right-click and click Insert) the definition in the Insert Property Definitions list. You can also select the definition, and press Insert. use a VBScript function locate and double-click (or right-click and click Insert) the function in the Insert VBScript code list. You can also select the function, and press Insert. evaluate the formula as a VBScript function enter RESULT anywhere in the formula. The property definitions available for use in the formula must be applied to the same objects as the property set definition containing the formula.
The names of property definitions used in the formula are displayed within brackets, such as [Width]. If a property definition belongs to a property set definition other than the one containing the formula, that name is displayed as well, such as [DoorObjects:Height].
The formula property definition cannot be used in the formula it defines, as indicated by the
and the addition of [Self] after its name. Property definitions that end up using the value of the formula cannot be used in the formula, as indicated by the and the addition of [Circular Reference] after their names. Note: If you enter the name of a property definition directly in the formula string, or copy and paste between formulas, the property definition is displayed as normal text. For property values of property definitions to be inserted correctly, they must be selected from the list in the Insert Property Definitions pane. - Enter a value in the Enter Sample Values pane.
The property value you enter displays in the current format specified.
- Select a property data format to specify how the property value is formatted in the formula.
The format you select becomes the default format in a formula when this property is added to a schedule table style. It can be changed at any time. The Example column on the Definition tab shows how the default value is displayed using the selected format.
- Click OK.