RevitCity.com Logo

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

Welcome !

62 Users Online (60 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

Search this ThreadSearch this Thread | Page 1 of 1 |

Tue, Apr 28, 2009 at 9:47:23 AM | sum parameter

#1

KKERRIDGE


active
KKERRIDGE Avatar

Joined: Wed, Jun 11, 2008
68 Posts
2.5 Stars: 3 Votes


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

 

Tue, Apr 28, 2009 at 10:47:51 AM | sum parameter

#2

travistlo


active

Joined: Tue, Nov 20, 2007
64 Posts
5 Stars: 2 Votes


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

Tue, Apr 28, 2009 at 11:07:25 AM | sum parameter

#3

KKERRIDGE


active
KKERRIDGE Avatar

Joined: Wed, Jun 11, 2008
68 Posts
2.5 Stars: 3 Votes


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

 

Tue, Apr 28, 2009 at 11:46:12 AM | sum parameter

#4

travistlo


active

Joined: Tue, Nov 20, 2007
64 Posts
5 Stars: 2 Votes


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

Tue, Apr 28, 2009 at 12:20:47 PM | sum parameter

#5

KKERRIDGE


active
KKERRIDGE Avatar

Joined: Wed, Jun 11, 2008
68 Posts
2.5 Stars: 3 Votes


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

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

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

Site Stats

Members:

1987601

Objects:

22875

Forum Posts:

152177

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.3120

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights