RevitCity.com Logo

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

Welcome !

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

 

Forums

Forums >> Revit Building >> Technical Support >> Schedule Count as Percent of Grand

Search this ThreadSearch this Thread | Page 1 of 1 |

Thu, Feb 15, 2007 at 1:52:54 PM | Schedule Count as Percent of Grand

#1

hippy


active

Joined: Tue, Jan 17, 2006
41 Posts
No Rating


This seems an easy concept but when I enter the formula I get an error count cannot be used in formulas. I need to show  that "room name count" / "grand total count" as a percentive. Someone has to have a work-around.

Thanks


This user is offline

 

Thu, Feb 15, 2007 at 4:22:33 PM | Schedule Count as Percent of Grand

#2

TomDorner


active

Joined: Sun, Apr 25, 2004
1207 Posts
4.5 Stars: 24 Votes


The built-in field of count cannot be used in a percentage calculation as the result would be meaningless which is why they don't allow it.  In order to give meaning to a room count one needs to group the database report [Revit schedule] on a meaningful field such as 'department' and create your own field called room count which is an integer and calculate out a percentage of that when grouped by department.

Alternatively, you can get a built-in room count if you sort/group by department, room type, name etc.

 



Attached Images

20511_schedule_count_1.jpg

-----------------------------------

Tom

www.reviteer.com   http://twitter.com/Reviteer

 

This user is offline

View Website

Wed, Dec 21, 2011 at 2:03:58 AM | Schedule Count as Percent of Grand

#3

lpnoble


active

Joined: Fri, Feb 29, 2008
32 Posts
No Rating


Sorry but I have a brain freeze, I am trying to accomplish this very thing and this explanation hasn’t sunk into to my thick skull!

I have different types of rooms

I have the count of each room type in the schedule

I have the total rooms at the bottom of the schedule (calculate totals switched on)

 

How do I get the percent of the room type to the grand total?


This user is offline

 

Thu, Dec 22, 2011 at 4:33:17 PM | Schedule Count as Percent of Grand

#4

lpnoble


active

Joined: Fri, Feb 29, 2008
32 Posts
No Rating


Well I did it!

This helped

http://forums.augi.com/showthread.php?t=50808&highlight=schedule+percentage+total

 


This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

ROOM COUNT SCHEDULE

Revit Building >> Technical Support

Tue, Aug 22, 2006 at 7:45:49 PM

1

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

Revit Building >> Technical Support

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

0

Schedule Count Parameter

Revit Building >> Tips & Tricks

Wed, Sep 2, 2009 at 4:02:10 PM

2

Grand total text

Revit Building >> Technical Support

Wed, Oct 21, 2009 at 4:14:58 PM

1

Schedules

Revit Building >> Technical Support

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

1

Site Stats

Members:

1622701

Objects:

22000

Forum Posts:

151622

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: 2.2410

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights