RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

252 Users Online (110 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

Forums >> Revit Building >> Technical Support >> Using schedule total in formula?

Search this ThreadSearch this Thread | Page 1 of 1 |

Wed, Apr 24, 2013 at 1:49:45 PM | Using schedule total in formula?

#1

dmhokie


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

 

Wed, Apr 24, 2013 at 4:08:50 PM | Using schedule total in formula?

#2

dgcad


active
dgcad Avatar

Joined: Fri, Mar 18, 2005
1231 Posts
3.5 Stars: 35 Votes


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

Wed, Apr 24, 2013 at 5:28:29 PM | Using schedule total in formula?

#3

dmhokie


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.



Attached Images

118999_Screen_Capture.png

This user is offline

 

Wed, Apr 24, 2013 at 5:49:11 PM | Using schedule total in formula?

Thread Post Kudo! #4

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 377 Votes


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

 

Wed, Apr 24, 2013 at 5:56:39 PM | Using schedule total in formula?

#5

dmhokie


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

 

Wed, Apr 24, 2013 at 7:05:33 PM | Using schedule total in formula?

#6

alfmedina


active
alfmedina Avatar

Joined: Wed, Sep 26, 2007
162 Posts
4 Stars: 8 Votes


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

Fri, Apr 4, 2014 at 12:10:47 AM | Using schedule total in formula?

#7

2con


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

 

Fri, Apr 4, 2014 at 12:36:33 PM | Using schedule total in formula?

#8

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 377 Votes


Read this thread for your solution. http://www.revitcity.com/forums.php?action=viewthread&thread_id=8844


This user is offline

 

Fri, Apr 4, 2014 at 2:54:11 PM | Using schedule total in formula?

#9

2con


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

 

Fri, Apr 4, 2014 at 3:29:50 PM | Using schedule total in formula?

#10

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 377 Votes


You can't use the total field from the column total.  Instead:

  1. don't show every instance
  2. In the field to be totaled, turn on calculate totals in the formatting
  3. Add a parameter that does your calculation using the rounding to get rid of the decimals

This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Calculated totals of formula in schedule

Revit Structure >> Technical Support

Fri, Sep 11, 2020 at 12:14:07 PM

7

Total number of units per floor in schedule without itemizing every instance

Revit Building >> Technical Support

Mon, Jul 27, 2015 at 10:25:58 PM

0

Total Mark Numbers vs Total Pieces in a Schedule

Revit Building >> Technical Support

Wed, Jan 14, 2015 at 7:23:39 PM

0

Schedules

Revit Building >> Technical Support

Thu, Oct 27, 2005 at 8:06:04 PM

1

Area schedule question: "Grand total" in formulas...

Revit Building >> Technical Support

Thu, Nov 26, 2009 at 11:54:29 AM

0

Site Stats

Members:

1781412

Objects:

22482

Forum Posts:

151948

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 0.4670

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights