How to Show Unit Cost and Total Cost in Revit Schedule

Do you need to show the Revit schedule with unit cost and total cost like the example below?

It is a standard format in showing a schedule. Logically, we think we can add a new parameter with the equation Count*Cost.

But Revit doesn’t accept it well. It will tell you this.

Count can’t be used in formulas, but you can set the parameter to count the total. Let’s see how it works here.

Create a Calculated Value Parameter

In Revit Schedule properties, add a calculated value parameter.

Name this parameter: Total Cost, change the parameter type to Currency and fill the Formula with Cost. The formula is case sensitive. To avoid mistake, you can click the button next to the formula field and select it from the list.

Click OK.

Change the Formatting for Cost and Total Cost

We have two parameters that show cost value. But we want one shows unit cost and another one shows total cost. We can change that option in the Schedule Properties, Formatting tab.

First, select Cost field. Rename the heading as Unit Cost. And make this field to show no calculation.

Second, select Total Cost field. For this field, make it shows calculate totals.

Click OK. You should see that now the schedule shows the cost for each unit, and also the total cost for that particular unit.

It’s easy, isn’t it?

About Edwin Prakoso

I work as a Sr. Technical Consultant in Tech Data Advanced Solutions Indonesia. I've been using AutoCAD since R14 and Revit since Revit Building 9. I occasionally write for AUGIWorld magazine and also active in Autodesk discussion forum.
I'm an Autodesk Certified Professional (ACP) for Revit Architecture and AutoCAD. I'm also a member of Autodesk Expert Elite, appreciation for individuals who give contribution to Autodesk community.
Connect with me on twitter or LinkedIn