|
|
Home | Forums |
Downloads | Gallery |
News & Articles | Resources |
Jobs | FAQ |
| Join |
Welcome !
|
46 Users Online (45 Members):
Show Users Online
- Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM |
Forums
Forums >> Revit Building >> Technical Support >> sum parameter
|
|
active
![KKERRIDGE Avatar](user_avatar/65242.jpg)
Joined: Wed, Jun 11, 2008
68 Posts
![2.5 Stars: 3 Votes](/images/stars_2.5.gif) |
Ive been scrolling through the help files for a while now, looking for anything that will work like an excell "sum" formula. I can get totals & counts in the schedules, but it doesnt look like I can then take and use them in a formula? I can make an integer parameter used as a count, but then there is no way that I can see to get a sum of all those into a formula. Is this correct, or is there an interesting work around that someone is using to solve this problem?
Edited on: Tue, Apr 28, 2009 at 9:47:55 AM
|
This user is offline |
|
![](images/spacer.gif) |
|
active
Joined: Tue, Nov 20, 2007
64 Posts
![5 Stars: 2 Votes](/images/stars_5.gif) |
Could you explain what result you are looking to obtain.
----------------------------------- Chatting it up on gmail - travistlo.j@gmail.com |
This user is offline |
View Website
|
![](images/spacer.gif) |
active
![KKERRIDGE Avatar](user_avatar/65242.jpg)
Joined: Wed, Jun 11, 2008
68 Posts
![2.5 Stars: 3 Votes](/images/stars_2.5.gif) |
in some other formula based programs such as excell, the equasion =sum(parameter or cell value) will give you the addition of all the cells in that range. The count & totals function of revit schedules works similarly, however I would like to have this "sum" shown in the schedule, not below it. I could acomplish this if there were a formula function similar to "sum"
|
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Tue, Nov 20, 2007
64 Posts
![5 Stars: 2 Votes](/images/stars_5.gif) |
I understand the theory of what you are trying to accomplish, but becuase revit is pretty complicated, most specifics are needed to give you a specific answer. I do not think you can access the "Count" Information. But I might be able to give you a solution. You can try this to see if it helps. Go to your schedule properties, go to the appearence tab, under the graphics section is a checkbox for Grid in Header/footers/spacer. That will make a grid line. Now mess around with your grouping to accomplish the sum(total) of what you are trying to count.
----------------------------------- Chatting it up on gmail - travistlo.j@gmail.com |
This user is offline |
View Website
|
![](images/spacer.gif) |
active
![KKERRIDGE Avatar](user_avatar/65242.jpg)
Joined: Wed, Jun 11, 2008
68 Posts
![2.5 Stars: 3 Votes](/images/stars_2.5.gif) |
thank you for giving it a try, it sounds like there is no way to acomplish totals or sums in the schedule cells instead of below the schedule (applying grids will not change the placement of the total) Hopefully it is something that can be taken can of through VSTA.
|
This user is offline |
|
![](images/spacer.gif) |
![](images/spacer.gif) |
Similar Threads |
REVIT sum up valves |
Revit Systems >> Technical Support
|
Wed, Nov 26, 2014 at 4:53:07 PM
|
1
|
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
|
Using schedule total in formula? |
Revit Building >> Technical Support
|
Fri, Apr 4, 2014 at 10:29:50 AM
|
1
|
Sum Total of areas |
Revit Building >> Technical Support
|
Tue, Apr 28, 2009 at 10:03:54 AM
|
2
|
? Passing parameter values either between hosted families or nested families ? |
Revit Structure >> Technical Support
|
Tue, Dec 21, 2010 at 2:21:47 PM
|
4
|
![](images/spacer.gif) |
|
Site Stats
Members: | 2022356 | Objects: | 22974 | Forum Posts: | 152200 | Job Listings: | 3 |
|