|
|
Home | Forums |
Downloads | Gallery |
News & Articles | Resources |
Jobs | FAQ |
| Join |
Welcome !
|
54 Users Online (53 Members):
Show Users Online
- Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM |
Forums
Forums >> General Discussion >> Revit Project Management >> Schedule -Adding column totals to text field parameters
|
|
active
Joined: Thu, Sep 27, 2012
0 Posts No Rating |
Hi all,
A colleague has asked me to look at an issue he has.
Screenshot attached of the schedule in question.
Each field from column B to J is a simple text field.
My colleague want to quantify the number of "yes" inputs in each column.
I know that if they were number fields, then yes it is easy. But as they are text fields, can this actually be done?
Excel can do it, and we are tryig to avoid exporting to excel just to get a total.
He is using Revit 2014.
Any feedback is welcome.
Cheers,
Kristian
|
This user is offline |
|
![](images/spacer.gif) |
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
![3.5 Stars: 391 Votes](/images/stars_3.5.gif) |
Sorry but Revit doesn't have many text functions. You can look in your help to see what is available.
|
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Mon, Feb 13, 2012
2 Posts No Rating |
The solution to this seems so simple I may be misunderstanding your question. To tally the total of 'yes' for one field you just need to filter your schedule. See my attached image for the settings- I tested with one parameter.
The schedule will only show those set to 'yes' and then give you a total. You could do this individually for each finish within the same schedule, or create the same schedule over and over and filter each one differently. Hope this makes sense for you!
*In theory you could also filter for all spaces that have both timber flooring and paint, or another combination, too*
-----------------------------------
Using Revit2014, dragging the rest of the company with me from AutoCAD2008. When will the whining stop? |
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Thu, Sep 27, 2012
0 Posts No Rating |
Thanks HKicsak,
Not quite what we had in mind.
We are trying to count the totals for EACH column within the one table, without filtering out the ones that dont equal "YES".
Impretty sure this cant be done in Revit with its limited scheuling functionality, but im happy to be proven wrong!
Thanks,
Kristian
|
This user is offline |
|
![](images/spacer.gif) |
![](images/spacer.gif) |
Similar Threads |
which parameters can have totals in schedules? |
Revit Structure >> Technical Support
|
Fri, Nov 8, 2013 at 10:37:49 AM
|
2
|
Text Wrapping in Door Schedule (in modify page, not when placed on sheet) |
Revit Building >> Technical Support
|
Tue, Jan 17, 2012 at 9:48:23 AM
|
2
|
Schedule Totals |
Revit Structure >> Tips & Tricks
|
Wed, Jan 6, 2010 at 2:00:46 PM
|
1
|
Totals for one column |
Community >> Newbies
|
Wed, Oct 20, 2010 at 9:20:24 AM
|
0
|
Duplicate Parameters in Schedule Field List |
Revit Building >> Technical Support
|
Wed, Nov 29, 2006 at 3:17:39 PM
|
9
|
![](images/spacer.gif) |
|
Site Stats
Members: | 2022340 | Objects: | 22974 | Forum Posts: | 152200 | Job Listings: | 3 |
|