• Home
  • CADnotes Store
    • AutoCAD Block Best Practices
    • Document Management with AutoCAD Sheet Set
  • Write for CADnotes
  • Email Newsletter
  • About
    • Contributors
    • Feedback
    • Contact
    • Privacy policy
    • Cookie Policy
  • Bahasa IndonesiaBahasa Indonesia

CADnotes

CAD Tutorials and Best Practices for professionals and students

  • Featured
  • AutoCAD
    • AutoLISP
  • Revit
    • Revit Architecture Basic
    • Revit MEP Basic Tutorial
  • Inventor
  • MicroStation
    • MicroStation Basic Tutorial

How to Show Unit Cost and Total Cost in Revit Schedule

October 6, 2018 by Edwin Prakoso Leave a Comment

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.

Advertisement - Article continues below

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 an Application Engineer in Jakarta, 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

Filed Under: Revit

Leave a Reply

avatar
wpdiscuz_captcharefresh
avatar
wpdiscuz_captcharefresh

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  Subscribe  
Notify of

Advertisement

Featured

10 AutoCAD temporary override keys

These AutoCAD temporary override keys can help you to quickly turn on/off AutoCAD features. Cool tools to increase productivity!

How to: Use Additional RPC in Revit

Dynamic Block Tutorial #1: Creating Wall

Advertisement

Get Connected


Meet the Authors

© 2009 – 2019 CADnotes · Feedback · Privacy Policy · Become an affiliate

wpDiscuz