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: Fri, Mar 18, 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 


