|
Forums >> Revit Building >> Technical Support >> Using schedule total in formula?
|
|
|
active
Joined: Wed, Feb 18, 2009
4 Posts
No Rating |
I am trying to reference a total from a column in a formula. The field that I am trying to reference is my total occupancy for a building. As in I am trying to make a formula that involves subtracting 50 from my total occupancy of 2000. If I just use my occupancy field in the formula, it takes 50 from each row of say 4 occupants in a room thus giving me a total of -1145. What I need to do is reference the total occupancy of 2000 and subtract 50, thus giving me 1950 in my formula. Can anyone help me on this/ does this make any sense?
|
This user is offline |
|
 |
|
|
|
active
Joined: Thu, Mar 17, 2005
1231 Posts
 |
Is it a 'Room' schedule ? What are you actually scheduling.
-----------------------------------
.
FULL 'DOWNLOAD ACCESS' to all 850+ CADclips videos for only $150
|
This user is offline |
View Website
|
|
|
active
Joined: Wed, Feb 18, 2009
4 Posts
No Rating |
It's an room occupancy schedule. I am trying to create a schedule that can essentially calculate how many plumbing fixtures we need based on code. For instance for toilets, the room's classification of education or business or assembly all have different requirements for toilets, sinks, water fountains, etc. I have a schedule of all of the room's occupancies and want to reference that total occupancy number in a formula.
If you look at my screenshot it may make more sense. The total occupancy is 2053 and I want to calculate how many toilets are required based on a formula referencing the total occupancy.
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
With every project, there are design issues and there are documentation issues. Revit can help with design issues but not everything needs to be in Revit. I would have exported a schedule to excel and have my formulas there.... as a matter of fact - that is exactly what we do.
|
This user is offline |
|
|
|
active
Joined: Wed, Feb 18, 2009
4 Posts
No Rating |
Sorry I don't know why my last post posted twice.
That is what we have been doing, but we are working on bringing as much into Revit as possible, so that as the design changes, all of our documentation changes with it. I am really also just trying to explore what can be done with scheduling in Revit. It becomes a little confusing and problematic that as a room changes during design, we have to redo a ton of steps to reinput data in excel then reimport/export stuff to get it back into Revit. I'm just trying to sample new ways to solve problems.
|
This user is offline |
|
|
|
active
Joined: Wed, Sep 26, 2007
162 Posts
 |
Formulas have effect on rows, but not on the totals. For doing extra calculations with the totals, continue in Excel.
-----------------------------------
Planta1 Revit Online Consulting | info@planta1.com |
This user is offline |
View Website
|
|
|
active
Joined: Tue, Nov 8, 2011
0 Posts
No Rating |
I built this calculator you are thinking of in excel and I have been recently trying to get it into revit. I have everything up to the washroom calculator. If it is true that you cannot use the sum function and add the total number of toilets per room (sum of that column) you can't finish it off because you get decimals numbers of toilets per room per floor etc.
if somebody know how to sum or add a column in revit 2014 that would be awesome!
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
Read this thread for your solution. http://www.revitcity.com/forums.php?action=viewthread&thread_id=8844
|
This user is offline |
|
|
|
active
Joined: Tue, Nov 8, 2011
0 Posts
No Rating |
This method is actually not as good as using an IF statement in revit, which i have used. I need a way to add an entire column so i can divide it by a number..
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
You can't use the total field from the column total. Instead:
- don't show every instance
- In the field to be totaled, turn on calculate totals in the formatting
- Add a parameter that does your calculation using the rounding to get rid of the decimals
|
This user is offline |
|
|
|
Similar Threads |
|
Calculated totals of formula in schedule |
Revit Structure >> Technical Support
|
Fri, Sep 11, 2020 at 7:14:07 AM
|
7
|
|
Total number of units per floor in schedule without itemizing every instance |
Revit Building >> Technical Support
|
Mon, Jul 27, 2015 at 5:25:58 PM
|
0
|
|
Total Mark Numbers vs Total Pieces in a Schedule |
Revit Building >> Technical Support
|
Wed, Jan 14, 2015 at 1:23:39 PM
|
0
|
|
Schedules |
Revit Building >> Technical Support
|
Thu, Oct 27, 2005 at 3:06:04 PM
|
1
|
|
Area schedule question: "Grand total" in formulas... |
Revit Building >> Technical Support
|
Thu, Nov 26, 2009 at 5:54:29 AM
|
0
|
|
Search
