|
|
|
Home | Forums |
Downloads | Gallery |
News & Articles | Resources |
Jobs | FAQ |
| Join |
Welcome !
|
76 Users Online (75 Members):
Show Users Online
- Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM |
Forums
|
Forums >> Revit Building >> Tips & Tricks >> Schedules - Costings
|
|
|
active
Joined: Tue, Jun 5, 2007
20 Posts
No Rating |
Had a couple of people ask me how to create a schedule of furniture including count, unit cost and total cost of each group of items....Revit has the issue that the Count field can't be used within a formula http://www.revitup.co.za/_mgxroot/page_10833.html Justin
|
This user is offline |
|
 | |
|
|
active
Joined: Tue, Jan 31, 2006
2 Posts
No Rating |
I'm trying to make a very simlar schedule for signage as in your example. I understand the need to add the addtional field, but what formula is in the Cost field and how do you get the totals in the footers?
|
This user is offline |
|
|
|
active
Joined: Tue, Jun 5, 2007
20 Posts
No Rating |
Marcia, In order to get totals in your schedules you need to edit the table and under the Formatting tab, tick the Calculate Totals for the required field you wish to total up. Then go to the Sorting and Grouping tab and tick Grand Total here as well (selecting Count and Totals, or Totals only depending on what you wish to do). Regarding the formula. This needs to be added to the Fields tab through the Calculated Value button. It's up to you what formula you wish to enter, but if you are for example mutiplying to fields then you must enter the field description exactly as it is listed. My formula for the material area was: Material: Area * Material: Cost / 1^ M2 Add the cost of your signs into the family through the Type Properties and then you table will able to pick the cost filed up. I hope that this helps. Justin
|
This user is offline |
|
|
|
active
Joined: Tue, Jan 31, 2006
2 Posts
No Rating |
Thank you. This did help, I wal just missing the formatting tab and the calculate total. I knew it was something simple. Marcia.
|
This user is offline |
|
|
|
active
Joined: Tue, Sep 4, 2007
8 Posts
 |
So does that mean you have to edit the properties and add a cost for every item?
|
This user is offline |
|
|
|
active
Joined: Sat, Feb 11, 2006
29 Posts
No Rating |
Hi, I read the message that you sent al long time ago. I wondered if you have solved the problem of using "count" in a formula. I want to calculate the total cost of furniture without haing to list all the individual items. If you have a solution, I would like to hear it. Eveline
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
 |
You don't need to add count. Try this experiment. - Have a cost assigned to all your furniture.
- Create a furniture schedule - just two fields - family and cost.
- For the cost field under formatting, check the cost field.
- Under sorting and grouping, uncheck itemize every instance.
- Hide the family field.
You should end up with a schedule that gives you the total cost of all your furnishings. Now you can modify this to sort / filter as you need.
|
This user is offline |
|
|
|
Similar Threads |
|
multiple schedules |
Revit Building >> Technical Support
|
Tue, May 1, 2012 at 1:04:42 PM
|
2
|
|
Schedules for Information In Schedules HAHA |
Revit Structure >> Technical Support
|
Mon, Feb 13, 2012 at 12:08:12 PM
|
1
|
|
Schedules on multiple sheets |
Revit Building >> Technical Support
|
Thu, Apr 27, 2006 at 11:01:59 PM
|
1
|
|
Large number of schedules |
General Discussion >> Revit Project Management
|
Mon, Jun 20, 2011 at 12:56:18 PM
|
5
|
|
Area Schedules showing Metric and Imperial |
Revit Building >> Technical Support
|
Thu, May 28, 2009 at 11:49:29 AM
|
4
|
|
|
Site Stats
Members: | 2003529 | Objects: | 22887 | Forum Posts: | 152177 | Job Listings: | 3 |
|
Search