Schedule
Calculations
Learn to create calculated values and apply conditional formatting in Revit schedules to automate data analysis and streamline your BIM workflow.
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
Key Terms to Know
The Calculated Value Formula
Anatomy of the Calculated Value Dialog
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
Example 1: Total Cost Column
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:
Discipline: Common
Type: Number
Formula: \( (\text{Room Area} / \text{Level Area}) * 100 \)
Example 3: Conditional Formatting
Applying Conditional Formatting
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
Common Mistakes to Avoid
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?