01 / 21
fx

Schedule
Calculations

Learn to create calculated values and apply conditional formatting in Revit schedules to automate data analysis and streamline your BIM workflow.

Autodesk Revit

What Are Schedule Calculations?

A schedule in Revit is a tabular view that extracts parameter data from your model elements. Schedule calculations let you go beyond raw data: you can create new computed columns using formulas that combine, transform, and analyze existing parameters.

Why Calculated Values Matter

★ Automation
No manual math: totals, ratios, and costs update instantly when the model changes.
★ Accuracy
Formulas eliminate transcription errors and keep your data consistent across sheets.
★ Insight
Derive metrics like cost per unit area or window-to-wall ratio directly inside Revit.

Key Terms to Know

1
Parameter: A named property of a Revit element (e.g., Area, Cost, Length).
2
Calculated Value: A new column derived from a formula that references existing parameters.
3
Conditional Format: A rule that changes cell appearance (color, font) when a condition is met.
4
Formula: An expression using operators like \( + \), \( - \), \( * \), \( / \) and functions applied to parameters.

The Calculated Value Formula

\( \text{New Column} = \text{Parameter A} * \text{Parameter B} \)
Result auto-updates when model changes

Anatomy of the Calculated Value Dialog

Calculated Value Name: Total Cost Discipline: Common Type: Currency Formula:
\( \text{Unit Cost} * \text{Count} \)
1 2 3 1 Give your column a descriptive name 2 Set the return type (Number, Currency, etc.) 3 Write the formula using parameter names

Calculated Values vs Conditional Formatting

Calculated Value Conditional Format
Purpose Creates new data Changes appearance
Output A new column with computed values Color, bold, or font change on existing cells
Uses Formula? Yes: arithmetic expressions Yes: conditional tests
Example \( \text{Area} * \text{Cost per m}^2 \) If \( \text{Cost} > 5000 \), color red
Access Schedule Properties > Fields tab Schedule Properties > Formatting tab

How to Create a Calculated Value

1
Open Schedule Properties: Select your schedule view, then click "Schedule Properties" in the ribbon.
2
Add Calculated Value: In the Fields tab, click "Calculated Value" (not "Add Parameter").
3
Name it: Enter a clear, descriptive name like "Total Wall Cost" or "Area Ratio".
4
Set Discipline and Type: Choose the data type that matches your result (e.g., Currency, Number, Length).
5
Write the Formula: Use exact parameter names and operators: \( + \), \( - \), \( * \), \( / \).
6
Click OK: The new column appears in your schedule, populated automatically.

Example 1: Total Cost Column

Type Unit Cost Count Total Cost Door - Single $350 12 $4,200 Door - Double $720 4 $2,880 Window - Fixed $480 20 $9,600
\( \text{Formula: Unit Cost} * \text{Count} \)

Example 2: Area Ratio Calculation

Suppose you need to find what percentage of the floor area each room occupies. Assuming you have a parameter for the total area of the level (e.g., a project parameter named "Level Area"), you can create a calculated value:

Name: Area Percentage
Discipline: Common
Type: Number
Formula: \( (\text{Room Area} / \text{Level Area}) * 100 \)

Example 3: Conditional Formatting

Room Name
\( \text{Area (m}^2\text{)} \)
Status Office A 25.4 OK Office B 18.7 OK Storage 8.2 TOO SMALL Conf. Room 42.1 OK
\( \text{Condition: if Area } < 10\text{, highlight red} \)

Applying Conditional Formatting

1
Open Schedule Properties and go to the Formatting tab.
2
Select the field you want to format (e.g., "Area" or your calculated value).
3
Click "Conditional Format" at the bottom of the Formatting tab.
4
Set the condition: choose a test like "less than", "greater than", or "equals" and enter a threshold value.
5
Choose the style: pick a background color, text color, or font style for matching cells.

Supported Operators in Formulas

Operator Symbol Example
Addition \( + \) \( \text{Length} + \text{Width} \)
Subtraction \( - \) \( \text{Budget} - \text{Actual Cost} \)
Multiplication \( * \) \( \text{Unit Cost} * \text{Count} \)
Division \( / \) \( \text{Area} / \text{Room Count} \)
Parentheses \( (\;) \) \( (\text{Length} + \text{Width}) * 2 \)

Formula Pattern: Percentage

Part Value
/
Whole Value
*
100 Percentage Result (%)

Common Mistakes to Avoid

✕ Wrong Parameter Name
Typing "area" instead of "Area" causes the formula to fail. Names are case-sensitive.
✕ Mismatched Units
Dividing length by area produces incompatible units. Ensure both sides of the operator make dimensional sense.
✕ Wrong Return Type
Setting "Type" to Length when your formula returns Currency makes the column display incorrect values.

Summary: Calculations at a Glance

Feature Calculated Value Conditional Format
Location Fields tab Formatting tab
Creates New Data? Yes No
Changes Appearance? No Yes
Requires Formula? Yes: arithmetic Yes: condition test
Common Use Totals, ratios, costs Flagging outliers, thresholds
Exports to Sheet? Yes Yes (visual only)

Question 1 of 5

Where do you create a calculated value in a Revit schedule?

Question 2 of 5

You want a column showing Total Cost where each row's value equals \( \text{Unit Cost} * \text{Quantity} \). Which formula would you enter?

Question 3 of 5

What does conditional formatting do in a Revit schedule?

Question 4 of 5

You create a calculated value that divides \( \text{Room Area} \) by \( \text{Level Area} \). What should you set the Type to?

Question 5 of 5

A formula reads \( \text{Budget} - \text{Actual Cost} \). If Budget is \( $50{,}000 \) and Actual Cost is \( $62{,}000 \), what will the calculated value show?